Show / Hide details with variable groups

[timstring]

I have been all over this site and haven't found anything that fits my particular needs.

Here's the general lay of my data:

[TABLE="width: 486"]
<tbody>[TR]
[TD]Count[/TD]
[TD]TechNum[/TD]
[TD]Name[/TD]
[TD]Problem[/TD]
[TD]Work Order[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3274[/TD]
[TD]Kevin Stedry[/TD]
[TD]Failed[/TD]
[TD]63665008_811[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3274[/TD]
[TD]Kevin Stedry[/TD]
[TD]Failed[/TD]
[TD]63758334_811[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3327[/TD]
[TD]David Bryan[/TD]
[TD]Failed[/TD]
[TD]915535_100[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]3327[/TD]
[TD]David Bryan[/TD]
[TD]Manual[/TD]
[TD]63771030_811[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]3363[/TD]
[TD]Carl Johnson[/TD]
[TD]Manual[/TD]
[TD]63765099_811[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]4289[/TD]
[TD]Jeff Robinson[/TD]
[TD]Failed[/TD]
[TD]63716893_811[/TD]
[/TR]
</tbody>[/TABLE]
I want to filter out all of the rows where Count = 1. Also, as you can probably guess, I want to collapse the rest of the rows to the level of Tech Number. The groupings are going to change day by day. Please point me in the right direction.

 

[timstring]

Ok, I figured out how to filter and hide detail. Now, how would I go about building a macro where the groups vary in size?