Worksheet & Formula Help Please!!
 

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth

Worksheet & Formula Help Please!!
 

Happy New Year, too.

Does your Formula results bear a text "January" or the formula contains
specific dates within January ?
If it will be just pure *text* replacement, it is not so difficult, but if
it is *date* related, then the year has to be specific for february's
concern.
Copying the whole tab formula may mean that it is a text output only.

--
regards



"Beth B" wrote:

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth

Worksheet & Formula Help Please!!
 

Thanks for your response. There are no dates involved. However there are
numerical calculations. I want a portion of the formulas to change from Jan
to Feb when copying the Jan worksheet to the Feb tab. How do I do this?

Thanks!!!

"driller" wrote:

Happy New Year, too.

Does your Formula results bear a text "January" or the formula contains
specific dates within January ?
If it will be just pure *text* replacement, it is not so difficult, but if
it is *date* related, then the year has to be specific for february's
concern.
Copying the whole tab formula may mean that it is a text output only.

--
regards



"Beth B" wrote:

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth

Worksheet & Formula Help Please!!
 

Nice one, can u please post at least one of the numerical calculation formula
with Jan to change to Feb - which has no date involved.
--
regards,



"Beth B" wrote:

Thanks for your response. There are no dates involved. However there are
numerical calculations. I want a portion of the formulas to change from Jan
to Feb when copying the Jan worksheet to the Feb tab. How do I do this?

Thanks!!!

"driller" wrote:

Happy New Year, too.

Does your Formula results bear a text "January" or the formula contains
specific dates within January ?
If it will be just pure *text* replacement, it is not so difficult, but if
it is *date* related, then the year has to be specific for february's
concern.
Copying the whole tab formula may mean that it is a text output only.

--
regards



"Beth B" wrote:

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth

Worksheet & Formula Help Please!!
 

I figured it out. You just select all of the cells with formulas and do a
simple find and replace. It was that simple!

Thanks!

"driller" wrote:

Nice one, can u please post at least one of the numerical calculation formula
with Jan to change to Feb - which has no date involved.
--
regards,



"Beth B" wrote:

Thanks for your response. There are no dates involved. However there are
numerical calculations. I want a portion of the formulas to change from Jan
to Feb when copying the Jan worksheet to the Feb tab. How do I do this?

Thanks!!!

"driller" wrote:

Happy New Year, too.

Does your Formula results bear a text "January" or the formula contains
specific dates within January ?
If it will be just pure *text* replacement, it is not so difficult, but if
it is *date* related, then the year has to be specific for february's
concern.
Copying the whole tab formula may mean that it is a text output only.

--
regards



"Beth B" wrote:

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth

Worksheet & Formula Help Please!!
 

I'm glad you figured it out so quickly by yourself.
--
regards



"Beth B" wrote:

I figured it out. You just select all of the cells with formulas and do a
simple find and replace. It was that simple!

Thanks!

"driller" wrote:

Nice one, can u please post at least one of the numerical calculation formula
with Jan to change to Feb - which has no date involved.
--
regards,



"Beth B" wrote:

Thanks for your response. There are no dates involved. However there are
numerical calculations. I want a portion of the formulas to change from Jan
to Feb when copying the Jan worksheet to the Feb tab. How do I do this?

Thanks!!!

"driller" wrote:

Happy New Year, too.

Does your Formula results bear a text "January" or the formula contains
specific dates within January ?
If it will be just pure *text* replacement, it is not so difficult, but if
it is *date* related, then the year has to be specific for february's
concern.
Copying the whole tab formula may mean that it is a text output only.

--
regards



"Beth B" wrote:

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth

Worksheet & Formula Help Please!!
 

Good thinking.

You'll soon be answering instead of asking<g


Gord Dibben MS Excel MVP

On Tue, 1 Jan 2008 18:38:00 -0800, Beth B
wrote:

I figured it out. You just select all of the cells with formulas and do a
simple find and replace. It was that simple!

Thanks!

"driller" wrote:

Nice one, can u please post at least one of the numerical calculation formula
with Jan to change to Feb - which has no date involved.
--
regards,



"Beth B" wrote:

Thanks for your response. There are no dates involved. However there are
numerical calculations. I want a portion of the formulas to change from Jan
to Feb when copying the Jan worksheet to the Feb tab. How do I do this?

Thanks!!!

"driller" wrote:

Happy New Year, too.

Does your Formula results bear a text "January" or the formula contains
specific dates within January ?
If it will be just pure *text* replacement, it is not so difficult, but if
it is *date* related, then the year has to be specific for february's
concern.
Copying the whole tab formula may mean that it is a text output only.

--
regards



"Beth B" wrote:

Hello!

Here's my situation. I have a workbook that has 12 worksheets titled the
months of the year. When I copy the entire January worksheet to the February
tab I want the formulas in the cells to change from January to February. How
do I make this happen on each of the worksheets when copying without having
to manually change each formula.

Any help would be much appreciated! Thanks and Happy New Year!

Beth