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€¦