View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KellyLC KellyLC is offline
external usenet poster
 
Posts: 1
Default Copying worksheets?

Is it possible to automatically change a specific formula which references
the previous worksheet? example:
Day 1 is subtracted from the Day 2 total, when I copy the sheet to name it
Day 3, I want the formula to subtract Day 2 from Day 3. I have to make 31
copies for each day of the month. Is there an easier way to make the change