| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull through totals to front page
I would like to pull through total amounts from a number of worksheets to sit
at the main front navigation page. Within the worksheets, the total figure sits in column C:3. Each worksheet has a different name - for example: Castlehead. Hope you can help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pull through totals to front page
Hello
Place the following formula into your main sheet =SUM(Zozo:Zaza!C3) Where Zozo is the name of your first sheet and Zaza is the name of your last sheet. See also Data, Consolidate. HTH Cordially Pascal "slavenp" a écrit dans le message de news: ... I would like to pull through total amounts from a number of worksheets to sit at the main front navigation page. Within the worksheets, the total figure sits in column C:3. Each worksheet has a different name - for example: Castlehead. Hope you can help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| Front page 2000 and Excell. | Excel Discussion (Misc queries) | |||
| Microsoft Office Pro with Front page | Excel Discussion (Misc queries) | |||
| Copy and Paste Macro for front totals sheet | Excel Discussion (Misc queries) | |||
| export excel to Front Page | Excel Discussion (Misc queries) | |||
Linear Mode
