beyond advanced filter

[davidb]

How can I continually filter a constantly growing list into sub categories?
Without having to manually advance filter and copy and past?

Eg

Category Vendor Date Amount
Subs Mill creek 1/1/07 $14.06
Auto Today 2/3/05 $400.07
Subs Tanner 3/5/06 $130.00
Home True Green 4/5/06 $50
Home True Green 5/6/06 $50
Entertainment StarBucks 7/9/07 $15
Auto Today 4/15/07 $600.67
Next entry---

(Filter to lists)
Category Auto
Vendor Date Amount
Auto Today 2/3/05 $400.07
Auto Today 4/15/07 $600.67
Total $1000.74

Category Subs
Vendor Date Amount
Subs Mill creek 1/1/07 $14.06
Subs Tanner 3/5/06 $130.00
Total $144.06

And so on…

 

[Gary''s Student]

I would insert a helper column with values 1,2,3,4,5,..............

Then I would sort on Catagory and copy/paste the specific catagories where
they are needed. The I would re-sort by the helper column to restore the
original order.

 

[davidb]

I’m trying to avoid the cut and past approach and am looking for an auto
mated feature to move the information by the values assigned.