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

  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

  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

Samsung Galaxy Book 2: Release date, price and specs

Adobe's groundbreaking prototypes of new features and apps for Creative Cloud

When is the next Apple event?

Test : le Samsung Galaxy A9