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