Hi all,

Looking for a shortcut to help with a new workbook. I created a book for the
month of January. Next, was a copy and paste for the month of March. But, of
course.it has January written in the tabs and formulas. Is there an easy way
to change the month in the whole book without having to go cell by cell?

Excel 2007 - find and replace - select formulas - then find and replace
January with March - the tab name you'll have to do manually
"Sherry S" wrote:

Hi all,

Looking for a shortcut to help with a new workbook. I created a book for the
month of January. Next, was a copy and paste for the month of March. But, of
course.it has January written in the tabs and formulas. Is there an easy way
to change the month in the whole book without having to go cell by cell?

Thanks, I'll give it a try.

"dhstein" wrote:


Excel 2007 - find and replace - select formulas - then find and replace
January with March - the tab name you'll have to do manually
"Sherry S" wrote:

Hi all,

Looking for a shortcut to help with a new workbook. I created a book for the
month of January. Next, was a copy and paste for the month of March. But, of
course.it has January written in the tabs and formulas. Is there an easy way
to change the month in the whole book without having to go cell by cell?

For future reference - don't code "January". Use a cell for example K1 to
put in today =TODAY() Then when you reference the month you can use
=MONTH(K1). Or you could hard code the number 1 in cell K1 - then do a
VLOOKUP against a table of months. So if K1 contained a 1 you would get
"January" Then in a new tab you would only need to modify K1 from 1 to 3 and
January would become March everywhere.


"Sherry S" wrote:

Thanks, I'll give it a try.

"dhstein" wrote:


Excel 2007 - find and replace - select formulas - then find and replace
January with March - the tab name you'll have to do manually
"Sherry S" wrote:

Hi all,

Looking for a shortcut to help with a new workbook. I created a book for the
month of January. Next, was a copy and paste for the month of March. But, of
course.it has January written in the tabs and formulas. Is there an easy way
to change the month in the whole book without having to go cell by cell?