Vertical Subtotals

G

Gemma

Hello,

I hope I am posting to the correct group.

I have received a spreadsheet from someone that has subtotals in it
(Data, Subtotals), but instead of the subtotals (the 1,2,3 in the top
left corner) being horizontal they are vertical. Does anyone know how
this is done? Could it be done through VBA? I have searched the
internet as well as a number of books on Excel and can't seem to find
this mentioned anywhere. Defintely has me intrigued.

Thank you very much for any help,

Michelle
 
D

Dave Peterson

Data|Group

It's not automatic like Data|subtotals, so they could have done lots of work.
 
V

Vaughan

They probably used the Data, Group & outline feature to group the data and added subtotals manually.
 
Top