Update all formulas on spreadsheet - Apr05! to May05!

V

~Valerie

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!.
 
M

Michael Gill

Hi Valerie,

You can use Find and Replace. Press the Options button and select Look in
Formulas. This will replace values in formulas.

Michael
 
V

Valerie

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.
 
Top