Excel group by?

[Danmilkman]

Hai everybody,

 

is it possible in excel to group data in vba with for example the subtotal function? and if so how? (code please)

 

example:

I have zipcodes containing different types of businesses. How can I show the totals of the total amount of profit in this category by grouping the type of business.

 

Thnx in advance,

 

Grtz,

 

D.