View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kai[_5_] Kai[_5_] is offline
external usenet poster
 
Posts: 2
Default Adding New Sheet, But Carrying Over Previous Sheet's Cell Calls

I have created a reporting workbook that currently takes reports
daily. However, I am limited to a certain number of days I am trying
to "sum" totals on. Sheet1 displays the of sum of last sheet directly
Sum(Sheet10!A1:D1). What I am trying to do is create a way I can keep
adding more sheets, but the call from Sheet1 updates to the latest
sheet added. Any ideas?