Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
beyond advanced filter
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€¦ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
beyond advanced filter
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€¦ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
beyond advanced filter
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€¦ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |