Changing ref's within formulas without having to retype each one.

  • Thread starter Thread starter Harley
  • Start date Start date
H

Harley

I need to change ref's (month's) within many formulas. Is there a shortcut to
help expidite this. For example, I have numerous formulas relating to each
month. I need to change all "JAN" refs to "FEB" refs for the appropriate
worksheet without having to retype each formula.

thanks,

Harley
 
Depending on how your formulas are structured, ou could just give a helper
cell the RangeName of JAN, and then just enter FEB in that cell..........

Vaya con Dios,
Chuck, CABGx3
 
Edit>Replace should get you there.

Replace what: JAN!

Replace with: FEB!


Gord Dibben MS Excel MVP
 

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

Macro to change formula? 5
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
14 Day Average REVISITED 3
#REF! errors 1
Cell ref is it possibile to calculate / change this in a formula 3
Excel Sumproduct Ref error when table is closed 0
Indirect function problem 4
#REF! error when copying formula beyond row 65536 in Excel 2007 1

Back
Top