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

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

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