Update all formulas on spreadsheet - Apr05! to May05!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forecast 4
Calculating Cells across worksheets?? 3
CSV->Excel Data Problem 1
return array result in cell based on comparing dates 7
How to create a 'dynamic' formula? 11
Using Excel Worksheet functions in Arrays 1
Excel references keep changing 1
vlookup 1

Back
Top