| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Links - Problem | Links and Linking in Excel | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Using a formulae within scenarios | Excel Discussion (Misc queries) | |||
| Automatic Chart Update? | Charts and Charting in Excel | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Linear Mode
