I have tabs JAN-07, FEB-07, etc. and one summary tab which pulls data from each month's tab. I want to be able to change one cell on the summary tab from JAN to FEB, etc. to change all my formulas on the summary but I'm unsure how.
Any suggestions would be appreciated.
Thanks,
Phillycheese
To change all instances of "Jan" to "Feb" you have 3 options:
1. Use Find/Replace. It's the easiest way. Not sure why you would insist on not using it.
2. Manually edit every formula.
3. Write a macro to find every Jan and replace it with Feb. While not as much work as option 2, it does the exact same thing as step 1 but requires you know how to code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks