Inserting a a totals row every nth row.

[Jake87]

I have a list that looks like this:


Site-----Month--Use
Site A----Jan---10
Site A----Feb---5
Site B ----Jan---12
Site B ----Feb---6
Site C----Jan---5
Site C----Feb---3

I need something that will insert a row underneath each individual site grouping and that will sum the use column to look like this:

Site-------Month-Use
Site A------Jan---10
Site A------Feb---5
Total-------------15
Site B ------Jan---12
Site B ------Feb---6
Total-------------18
Site C------Jan---5
Site C------Feb---3
Total--------------8

I understand and can use a pivot table to do this, however i am looking for an alternative, as a pivot table will not work for what i need this to do. Can this be done somehow by pasteing a totals row every nth row or through a macro?

Thanks for any help in advance!

 

[VoG]

Any suggestions?

Yes, with respect, start your own thread. Your requirement bears little resemblance to the original question.