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
> >