Excel Gurus help required

  recap 15:42 04 Sep 03
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 03

look hear you may have to register click here

  seancblack 16:17 04 Sep 03

=[filename]Sheet#!CELL

  seancblack 16:18 04 Sep 03

remoce word CELL and replace with cell reference number

  recap 16:20 04 Sep 03

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 03

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 03

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.

Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

This 2D animation about monsters is illustrated in a Van Gogh painterly style

Siri not working? Try these troubleshooting fixes