Automatic row Grouping

[MDA]

Hi all,

I was wondering if there is a way to automatically group rows using vba. I am pushing data from a report into Excel and the layout would be like:

REVENUE
- 3000
- 3010
- 3020
- etc

COGS
- 4000
- 4010
- 4020
- etc

I want to group the detail lines up to the heading lines all automatically. I was thinking that I could have a hidden column that is a descriptor like 1 for a top level and 2 for a detail line but not sure how to approach this??

Has anyone attempted anything like this or have any idea how I would start??

I assume I would need to build an addin as the data will come from a report writer...

Any ideas are greatly appreciated.

Regards,
MDA

 

[SkipVought]

Hi,
Check out xlbo's posting on thread707-272117.

Skip,
metzgsk@voughtaircraft.com