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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal Subtotals 3
Subtotal appears at the beginning instead of the end.... 3
Subtotals 5
Hiding Columns (using Subtotal???) 2
Filtering With Subtotals. 2
Extremely slow subtotals in Excel 2003 3
How do I sort pivot table data by subtotals? 2
Subtotals by count 1

Top