Thread: Copying Sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stacy C[_2_] Stacy C[_2_] is offline
external usenet poster
 
Posts: 14
Default Copying Sheets

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.