D
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…
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…