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