Refer new sheet to previous sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot from multiple sheets 1
Dynamic sheet reference in Name formula 1
sum on multiple worksheets 0
Excel - Summing common cell over mutiple sheets within a file? 5
Use Text and Cell vale to reference a named range inside a formula 1
Vlookup using if condition or any other way to slove problem 3
Create a text based count with criteria from two differnt workbook 4
Formulas That Reference ADJACENT Sheet 4

Back
Top