Automatically carrying over totals on worksheets
by -DJ7- - 3/25/12 10:19 AM
I'm working in Excel '08 for Mac and want to know if there is a way to automatically carry over totals from one worksheet to another (within the same spreadsheet).
My spreadsheet consists of 12 (monthly) worksheets. Each sheet consists of 6 columns, 1 row of headers, 1 row with the prior month's balance, apx. 16 rows for each months specific expenses, and a final row for the total ledger balance.
I know how to manually get the prior month's ledger balance onto each worksheet (i.e. ='sheet name'!F20) but would like to know if there is a way to set it up so the sheet name automatically changes.