I hope this isn't an idiot question - apologies if it is.
I have two spreadsheets - one is a complicated spreadsheet produced by our accounts department each month which contains many worksheets, one of which (P&L) has the data I want to extract. I have created a simple worksheet (MonthlyCalcs) in my copy of the accounts spreadsheet with the formulae to take the figures I want from P&L. I want to be able to copy this MonthlyCalcs worksheet into next month's Accounting spreadsheet, but when I do this, the formulae retain the name of the original spreadsheet as a prefix to the formula. How do I break this link and get the formula to use the worksheet name in the spreadsheet into which it's been copied?
I have two spreadsheets - one is a complicated spreadsheet produced by our accounts department each month which contains many worksheets, one of which (P&L) has the data I want to extract. I have created a simple worksheet (MonthlyCalcs) in my copy of the accounts spreadsheet with the formulae to take the figures I want from P&L. I want to be able to copy this MonthlyCalcs worksheet into next month's Accounting spreadsheet, but when I do this, the formulae retain the name of the original spreadsheet as a prefix to the formula. How do I break this link and get the formula to use the worksheet name in the spreadsheet into which it's been copied?