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

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.

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