View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harley Harley is offline
external usenet poster
 
Posts: 16
Default Changing ref's within formulas without having to retype each one.

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