Code for Subtotalling?

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

Has anyone any code for subtotalling the same as the built in facility
EXCEPT not to subtotal where there is only one line of data? Also on true
subtotal lines it would be useful to sum some columns, average others and
count others but perhaps I am getting too complicated!
 
Take a look at the pivot table options in Excel, you can specify the
grouping variables (for sub totalling) and the sumary statistics you
require. Far better than writing VBA code to do it.

Cheers
Nigel
 
Back
Top