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

  [DELETED] 16:17 04 Sep 2003

=[filename]Sheet#!CELL

  [DELETED] 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

  [DELETED] 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

Microsoft Surface Book 2 15in review

Iglooghost's hyper new music video gives a mutant take on Monument Valley

The best Amazon Prime Day Apple deals 2018

Comment ajouter de la musique à une présentation Google Slides ?