R
Rick
I have a workbook where I add a new worksheet each week. Each sheet contains
cells with formulas that reference the worksheet from the previous week.
When I add a new worksheet, I copy the formulas from the previous week, but
it continues to reference the week prior to that. I must manually update
each reference, and it's getting old. Any suggestions?
cells with formulas that reference the worksheet from the previous week.
When I add a new worksheet, I copy the formulas from the previous week, but
it continues to reference the week prior to that. I must manually update
each reference, and it's getting old. Any suggestions?