Forum Discussion

Bobby Beckstrom's avatar
Bobby Beckstrom
Copper Contributor
Apr 28, 2018

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 spreadsheet as my master copy.  I need to open new spreadsheets from time to time and copy these sheets from the master copy to the new spreadsheet, but when I do this, my first sheet in the new spreadsheet is looking up those values in the master copy spreadsheet, I don't want that, I want it to lookup the values in the new spreadsheet I've copied to...please help

excel

1 Reply

Sort By
  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor
    Apr 28, 2018

    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

Resources