Excel Gurus help required

  recap 15:42 04 Sep 2003
Locked

Hi All,

I am trying to insert the value of a cell from one work book sheet1 to another work book. The forumlae I have tried is: =sum("filename!sheet#.cell") and as you can see it doesn't work.

Can somebody show me where I am going wrong please?

  woodchip 16:14 04 Sep 2003

look hear you may have to register click here

  seancblack 16:17 04 Sep 2003

=[filename]Sheet#!CELL

  seancblack 16:18 04 Sep 2003

remoce word CELL and replace with cell reference number

  recap 16:20 04 Sep 2003

Thanks woodchip, got it sorted. Amazing what a cuppa tea will do to the brain. This is howit now works: ='[filename]sheet'!cell

thanks for your help

  keef6 16:20 04 Sep 2003

have both workbooks open, preferably tiled side by side. In the second workbook, go to the cell where you want the result to appear and type = then simply click on the cell in the first workbook where the value is, and hit enter. It does the correct formula for you.

  recap 16:22 04 Sep 2003

Thanks seancblack, I should have explained that I displayed it that way to save confusion with cell and sheet and workbook numbers.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?