S
Stacy C
Good afternoon,
I am working on a spreadsheet, where I am creating copies of a master page
to use for each month of the year. As an example:
Sheet 1 & 2 will be copied to Sheet 3 & 4, where sheet 4's formulas will
need to reference sheet 3.
I know when I copy, all of the formulas will reference the original sheet.
Is there an easier way to have Sheet 4's formulas automatically reference
Sheet 3 (rather than Sheet 1), than to go in and manually edit the formulas
on the sheet itself?
Thank you for any advice.
I am working on a spreadsheet, where I am creating copies of a master page
to use for each month of the year. As an example:
Sheet 1 & 2 will be copied to Sheet 3 & 4, where sheet 4's formulas will
need to reference sheet 3.
I know when I copy, all of the formulas will reference the original sheet.
Is there an easier way to have Sheet 4's formulas automatically reference
Sheet 3 (rather than Sheet 1), than to go in and manually edit the formulas
on the sheet itself?
Thank you for any advice.