Help!! Group Data based on multiple criteria

[MI man]

Hello,
I am working on a data of 7 columns, of which the column B (Manager) is the one that I am using as the main criterion to group data. The problem is, there are n number of managers.
I can group them by using subtotal, but I would get an extra column giving me the subtotals, which is not required.
And moreover, since the data in all the columns are generated through VBA code, intrusion of an extra column is not desirable (as it would change the column references)

What I want:
I want to group data based on Managers, giving it an expansion and collapse look (just like subtotal gives). For each Manager, there should be one expand/collapse button.
Request you to provide me the code since one cannot say how many rows of data would be fetched each time.

Could anyone help?
P.S. I have attached a sample file here.
I use Excel 2003 version.

 

[noboffinme]

Hi MI Man,

Are you looking for a count of the managers names per Manager?

Is it possible to use a Pivot table like the one attached below?

Not exactly sure what you need.

 

[MI man]

Hi noboffinme,

I am looking something like what I have attached here.

I think a code with For loop and Group property would do.

I will try for it.

 

[noboffinme]

OK, you could record a Macro to help you write your group code.

 

[Brianwarnock]

Hi noboffinme,

I am looking something like what I have attached here.

I think a code with For loop and Group property would do.

I will try for it.

I cannot see how that differs from a simple sort on the manager column.

Brian