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?
look hear you may have to register click here
Thanks woodchip, got it sorted. Amazing what a cuppa tea will do to the brain. This is howit now works: ='[filename]sheet'!cellthanks for your help
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 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
© Copyright 2018 IDG UK. All Rights Reserved.