![]() |
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 |
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