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

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.
--
Gary''s Student - gsnu200792


"davidb" wrote:

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

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200792


"davidb" wrote:

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