Update formulae

[Fionn the Consultant]

Financial planning spreadsheet containing many long interdependent formula
needs to be updated from 04 to 05. Is there some quick way of editing this
(ie find/replace)?

 

[Dave O]

Hi, Fionn-
The answer is "Probably yes", but will you please provide an example of
a formula? If it was a simple search and replace you probably would
have done it already. Is it a matter of changing a cell reference from
'SheetName'!A1 to 'SheetName'!B1, where A1 is a 2004 total and B1 is a
2005 total?