Thread: [Solved] Carry-forward: Tab to Tab?
View Single Post
 
Old 01-27-2011, 10:07 AM
markg2 markg2 is offline Windows 7 Office 2007
Expert
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default 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
Reply With Quote