| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal Macro Through Numerous Tabs
I'm looking for a macro that will subtotal data on each tab in a worksheet
that has many tabs - and which the number of tabs fluctuates. Basically: (unsorted source data in sheet1, data sorted by account # on each tab starting in sheet2) Subtotal at change in column B; Sum columns A - K for sheet2, then again on sheet3, and so on until there are no more tabs. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
| macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
| Average percentage excluding zeros spanning numerous tabs | Excel Discussion (Misc queries) | |||
| Numerous OR criteria in a Filtered Macro | Excel Programming | |||
Threaded Mode
