Carry-forward: Tab to Tab?
XP + Office '03
For example, a workbook file containing 3 tabbed spreadsheets. The spreadsheets represent successive months of the year. Once the first tab (month) is completed the second (month) tab is started using the identical layout and formulas contained in the first--minus data input.
The second sheet wants to start with totals from the first and the third with totals from the second and so on.
How do I arrange a formula that will bring the total (of a formula) from a cell in Tab 1 to a cell in Tab 2?
Thanks,
Mark
|