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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…