| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list totals for various sheets
I have several worksheets (could be 2, could be 20) and I want to list the
totals into one final sheet |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
list totals for various sheets
List your sheet names in one column (eg column A), then in B1 use this
formula: =INDIRECT("'"&A1&"'!H13") This assumes your total is in cell H13 on each sheet - adjust to suit, then copy down. Hope this helps. Pete On Dec 15, 8:53*am, Tony H wrote: I have several worksheets (could be 2, could be 20) and I want to list the totals into one final sheet |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
list totals for various sheets
Many thanks. Works a treat.
Tony H "Pete_UK" wrote: List your sheet names in one column (eg column A), then in B1 use this formula: =INDIRECT("'"&A1&"'!H13") This assumes your total is in cell H13 on each sheet - adjust to suit, then copy down. Hope this helps. Pete On Dec 15, 8:53 am, Tony H wrote: I have several worksheets (could be 2, could be 20) and I want to list the totals into one final sheet |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
list totals for various sheets
You're welcome, Tony - thanks for feeding back.
Pete On Dec 15, 10:31*am, Tony H wrote: Many thanks. Works a treat. Tony H |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals linked from other sheets | Excel Worksheet Functions | |||
| specific totals from sheets represented on other sheets | Excel Discussion (Misc queries) | |||
| Can I show totals from sheets 2 &.3 on sheet 1 | Excel Worksheet Functions | |||
| Add row above TOTALS to all sheets when done in one sheet. | Excel Worksheet Functions | |||
| calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
Linear Mode
