Refer new sheet to previous sheet
 

Hello and thanks for your time.


Here's my problem:

I have a sheet called "Mar" that contains several cells that = cells on a
sheet called "Feb". Then, the next month I create a new sheet called "Apr".
To create this new sheet, I simply copy and paste "Mar" and rename it.
Obviously the cells with the = symbol still read (i.e.) =Feb!B10. I have
been going into each cell and replacing the text Feb with Mar.

I KNOW there must be an easier way. I just don't know it.

I am self taught in Excel, and I'm sure this question is quite elementary.
Unfortunately, I can't figure it out.

Thank you in advance for your help!


Spot, the Accountant

You could use find and replace (Ctrl+F). In your "Apr" sheets find all "Feb"
and replace with "Mar".

"Spot" wrote:

Hello and thanks for your time.


Here's my problem:

I have a sheet called "Mar" that contains several cells that = cells on a
sheet called "Feb". Then, the next month I create a new sheet called "Apr".
To create this new sheet, I simply copy and paste "Mar" and rename it.
Obviously the cells with the = symbol still read (i.e.) =Feb!B10. I have
been going into each cell and replacing the text Feb with Mar.

I KNOW there must be an easier way. I just don't know it.

I am self taught in Excel, and I'm sure this question is quite elementary.
Unfortunately, I can't figure it out.

Thank you in advance for your help!


Spot, the Accountant

David:

Thank you. Thank you. What a time saver! I knew someone would say,
"That's easy to solve", but you are the ONLY person to reply to my question.

Thanks again!
--
Spot, the Accountant


"David Hepner" wrote:

You could use find and replace (Ctrl+F). In your "Apr" sheets find all "Feb"
and replace with "Mar".

"Spot" wrote:

Hello and thanks for your time.


Here's my problem:

I have a sheet called "Mar" that contains several cells that = cells on a
sheet called "Feb". Then, the next month I create a new sheet called "Apr".
To create this new sheet, I simply copy and paste "Mar" and rename it.
Obviously the cells with the = symbol still read (i.e.) =Feb!B10. I have
been going into each cell and replacing the text Feb with Mar.

I KNOW there must be an easier way. I just don't know it.

I am self taught in Excel, and I'm sure this question is quite elementary.
Unfortunately, I can't figure it out.

Thank you in advance for your help!


Spot, the Accountant