|I have 2 MS Office .xls spreadsheets that have exactly the same headings / cell references for data etc - 2 consecutive years of the same budget. |
However, one of them is missing a sheet that helps me calculate a 'running total' of all the other sheets. It's essentially a page of calculations like
I want to copy that sheet from the first spreadsheet to the second, so I've created a blank sheet on the second .xls and then pasted the info from the sheet. Sounds easy right? Unofrtunately not. When I paste the info from the first .xls to the 2nd.xls it pastes a formula like this one:
=SUM('[NAME OF THE FIRST SPREADSHEET.xls]National'!B7+[NAME OF THE FIRST SPREADSHEET.xlsQueensland!B7+[NAME OF THE FIRST SPREADSHEET.xlsTasmania!B7+[NAME OF THE FIRST SPREADSHEET.xlsWA!B7+[NAME OF THE FIRST SPREADSHEET.xlsNSW!B7)
My question is how I can make it reference the spreadsheet I pasted it INTO - not the one I pasted it from. This will save me hours of work, thanks in advance for your help.
ie it's referencing the data back to the first .xls - not the one it's in.