Create two new worksheets--one to the far right and one to the far left.
Call them Start and End
Then using a sheet (Summary) that is outside this "sandwich" of worksheets:
=sum(start:end!B37)
Then you can drag sheets in and out of that sandwich to play what if games.
I'd put a couple of notes on each of these sheets:
"don't delete this sheet!"
And protect the worksheet so that people don't use it for real data.
ACM wrote:
I have a workbook with 12 worksheets and I need to sum 1 cell (ex. B37) on
each worksheet on one summary page. How can I track the cell from the
different worksheets to add them?
--
Dave Peterson
|