Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting results on separate tabs
Hello,
I have an Excel spreadsheet that has several tabs for diff categories. on one tab, i have set up a simple sum formula to add up current expenditures and totals (orig. budget balance and also funds available). so, i would like to do a sort of "cover page" for all the tabs in this Excel file, and "link" the automatic sums that appear on one tab to this front page tab. Is there a way to copy a formula that will automatically update on this separate page to correspond to the other page /info added to that page? Please help! Maria |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting results on separate tabs
hi
on your cover page, put a forumal like this... =sheet2!A1 this will bring the contents of the cell A1 on sheet 2 to the cover sheet. you can also use sheet names in the formula. you will need a formula for each cell total on the other sheets. adjust your your data. Regards FSt1 "josephone baker" wrote: Hello, I have an Excel spreadsheet that has several tabs for diff categories. on one tab, i have set up a simple sum formula to add up current expenditures and totals (orig. budget balance and also funds available). so, i would like to do a sort of "cover page" for all the tabs in this Excel file, and "link" the automatic sums that appear on one tab to this front page tab. Is there a way to copy a formula that will automatically update on this separate page to correspond to the other page /info added to that page? Please help! Maria |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine data (not consolidate) from separate tabs to one? | Excel Discussion (Misc queries) | |||
Separate Text Results | Excel Discussion (Misc queries) | |||
Can you separate multiple tabs each into their own file | Excel Worksheet Functions | |||
V lookup in separate TABS! | Excel Discussion (Misc queries) | |||
Exporting Excel Charts in Separate Tabs | Excel Discussion (Misc queries) |