Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find & replace??
Every year I run into same problem/inconvenience.
Have a spread sheet set up with 12 monthly pages named Jan 200x, Feb 200x + recap sheet and income sheet. The first year this was setup was 2005. Last year I manually renamed all pages and formulas to 2006. Is they a "better/easier" way of changing all the 2006 to 2007? L. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find & replace??
This may be too obvious to be the right answer, but....
If the workbook only contains data for a specific year, why would you need more than the month in the tab name? For example, if the workbook pertains to FY2006, tabs name JAN, FEB....DEC would obvously contain data for that year, right? After year-end, just SAVE AS the workbook to reference FY2007. .....or am I missing something? *********** Regards, Ron XL2002, WinXP "L." wrote: Every year I run into same problem/inconvenience. Have a spread sheet set up with 12 monthly pages named Jan 200x, Feb 200x + recap sheet and income sheet. The first year this was setup was 2005. Last year I manually renamed all pages and formulas to 2006. Is they a "better/easier" way of changing all the 2006 to 2007? L. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find & replace??
Ron Coderre wrote: This may be too obvious to be the right answer, but.... If the workbook only contains data for a specific year, why would you need more than the month in the tab name? For example, if the workbook pertains to FY2006, tabs name JAN, FEB....DEC would obvously contain data for that year, right? After year-end, just SAVE AS the workbook to reference FY2007. ....or am I missing something? *********** Regards, Ron XL2002, WinXP "L." wrote: Every year I run into same problem/inconvenience. Have a spread sheet set up with 12 monthly pages named Jan 200x, Feb 200x + recap sheet and income sheet. The first year this was setup was 2005. Last year I manually renamed all pages and formulas to 2006. Is they a "better/easier" way of changing all the 2006 to 2007? L. Assuming there are only 12 sheets and each one has a name like "Jan 200x" then you could use a macro Sub RenameSheets() Dim sh As Worksheet For Each sh In ActiveWorkbook.Sheets sh.Name = Replace(sh.Name, "06", "07") Next sh End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
find & replace??
Actually, you're not, missing something....
Had a friend help set this up for me but your suggestion should work fine. I've taken out the year's' and it appears the formulas picked up the changes. Everything appears to be working fine. thanks, L. "Ron Coderre" wrote in message ... This may be too obvious to be the right answer, but.... If the workbook only contains data for a specific year, why would you need more than the month in the tab name? For example, if the workbook pertains to FY2006, tabs name JAN, FEB....DEC would obvously contain data for that year, right? After year-end, just SAVE AS the workbook to reference FY2007. ....or am I missing something? *********** Regards, Ron XL2002, WinXP "L." wrote: Every year I run into same problem/inconvenience. Have a spread sheet set up with 12 monthly pages named Jan 200x, Feb 200x + recap sheet and income sheet. The first year this was setup was 2005. Last year I manually renamed all pages and formulas to 2006. Is they a "better/easier" way of changing all the 2006 to 2007? L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
Find comment replace cell value | Excel Discussion (Misc queries) | |||
How do I find and replace the " | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Problem with Find and Replace | Excel Worksheet Functions |