Nested subtotals macro

**jmurray** · 07-13-2009, 05:41 AM

Hi

I have a table of data - see first sheet of the attached file as an example (the 'Data' sheet) - I need to sort and subtotal this data by two different columns. The result I'm trying to obtain can be seen on the second sheet of the file. In other words, I need to create subtotals for one column within the subtotal of another column - best to look at the file example to see what i mean.

Appreciate any help with this.

John

**Bob Phillips** · 07-13-2009, 06:40 AM

Please Login or Register  to view this content.

**jmurray** · 07-13-2009, 08:14 AM

Hi Bob

Thanks for this - however, it didn't work as required.

A couple of problems:
- one of the groupings didn't get subtotalled (see attached - highlighted in yellow).

- the nesting hasn't come out as required - one layer missing (see comparison with second sheet).

Also, i need to be able to adapt this macro to a larger table of data which has many more columns, where columns B & C would be located in columns D & K respectively in a table with data in columns A-T.

I'm hoping this isn't too difficult - I tried adjusting the column coding in your macro but the macro only subtotalled by column D.

Appreciate your help again if poss.

Cheers
John

**Bob Phillips** · 07-13-2009, 08:55 AM

When I run it that layer is not missing, I get DEF Costs.

**Bob Phillips** · 07-13-2009, 09:07 AM

I see, you want the subtotals in a different order and must have changed the code for that. It needs further mod

Please Login or Register  to view this content.

**jmurray** · 07-13-2009, 10:38 AM

Hi Bob

for some reason this is not working on my pc.

It seems to work for the first half of the data, but then it goes a bit funny after that.

Not quite sure what your For next loops are doing - can you explain?

Ta
John

**Bob Phillips** · 07-13-2009, 11:03 AM

It seems to work fine for me.

The first loop goes through and recalculates all of the subtotal ranges, the second then goes and deletes all of the reeptitions of the subtotals in column B.

**zhzahidhussain** · 02-09-2010, 01:36 PM

Dear Bob

Your macro did work very well with the file you guys were working on. I tried to apply that macro on my file (attached) and changed the macro accordinlgy but it didn't work. Could you please help me. I need the result of subtotal using macro as in the attached file

Thanks

Zahid

**DonkeyOte** · 02-09-2010, 01:40 PM

Zahid,

Welcome to the board, however, please note

Your post does not comply with Rule 2 of our Forum RULES.

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.