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?
|