| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Update all formulas on spreadsheet - Apr05! to May05!
Update all formulas on spreadsheet - including array formulas by using
something similar to a find & replace function. Example change Apr05! sheet reference in all formulas to May05!. |
|
#2
|
|||
|
|||
|
Hi Valerie,
You can use Find and Replace. Press the Options button and select Look in Formulas. This will replace values in formulas. Michael "~Valerie" wrote: Update all formulas on spreadsheet - including array formulas by using something similar to a find & replace function. Example change Apr05! sheet reference in all formulas to May05!. |
|
#3
|
|||
|
|||
|
Thank you! This will save me a lot of time and effort.
Now I'm looking for "pivot table" simplified instructions and macros to update graphs and charts. Seems like always one more thing to learn. Thanks - again. I appreciate the help. "Michael Gill" wrote: Hi Valerie, You can use Find and Replace. Press the Options button and select Look in Formulas. This will replace values in formulas. Michael "~Valerie" wrote: Update all formulas on spreadsheet - including array formulas by using something similar to a find & replace function. Example change Apr05! sheet reference in all formulas to May05!. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
| How do I set up an excel spreadsheet to update every time a user . | New Users to Excel | |||
| Cut and Paste into spreadsheet with locked formulas | Excel Worksheet Functions | |||
| Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions | |||
| copy worksheet ... formulas do not update | Excel Worksheet Functions | |||
Hybrid Mode
