Forum Discussion
Copying Workbooks
Hi, wondering if anyone can help me. I've created a spreadsheet and the first sheet is my totals sheet, this sheet has formulas that lookup values in sheet2 thru sheet99. I've saved this spreadshee...
Hi
1.Don't put formula with file name (sheet name is exceptional) in first sheet.
(Eg. ='D:\Others\[Master Sheet.xlsx]Sheet2'!$H$4+'D:\Others\[Master Sheet.xlsx]Sheet3'!$H$4)
Put formula as "='Sheet2'!H4+'Sheet3'!H4" without file name. And dont delete sheets 2 to 99.
2. Or else forward the Master Sheet