Easy way to reference a specific cell in a new worksheet

  • Thread starter Thread starter Dan S
  • Start date Start date
D

Dan S

This project is for week over week sales. A new worksheet is added every
week. The current week's sales are in Column E for every salesperson and the
previous week's sales are in Column F. I would like the Column F to
automatically reference Column E on the previous worksheet every time a new
worksheet is added by copying the previous worksheet. It's not that hard to
work around it now, I would just like to save time and automate the process.
Is this possible? Let me know if what I am attempting to do does not make
sense.

TIA
 
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

Comparing lists 1
Copy compare worksheets 1
incorporate paste value in vlookup 1
VBA - retrieve data on last create named range from previous inserted named range 0
making cells uncopyable 1
Autofill Increment a Reference to Another Worksheet 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Changing column reference for number of formulas at once 1

Back
Top