| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub totalling in VBA
Is it possible to replicate the subtotaling Excel does in DataSubtotals
using VBA? I don't need the 3 worksheets layout, just a single worksheet sorted by (say)column A then and subtotalling selected columns after each of record in column A. Any ideas gratefully recieved. Thanks -- Peter London, UK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sub totalling in VBA
Turn on the macro recorder when you sort your data, then apply data|subtotals.
But I'm not sure what the "3 worksheets layout" is. Peter wrote: Is it possible to replicate the subtotaling Excel does in DataSubtotals using VBA? I don't need the 3 worksheets layout, just a single worksheet sorted by (say)column A then and subtotalling selected columns after each of record in column A. Any ideas gratefully recieved. Thanks -- Peter London, UK -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable totalling | Excel Discussion (Misc queries) | |||
| Totalling volumes per box | Excel Worksheet Functions | |||
| totalling | Excel Discussion (Misc queries) | |||
| Totalling x no of cols | Excel Programming | |||
| Totalling lists | Excel Discussion (Misc queries) | |||
Hybrid Mode
