ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Update formulae (https://www.excelbanter.com/excel-discussion-misc-queries/4175-update-formulae.html)

Fionn the Consultant

Update formulae
 
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)?
--
Fionn

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?



All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com