Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter
Thank you to anyone who can help.
I have three worksheets. In the first worksheet I have my source data, and one of the data fields indicates if the data goes into bucket 1 or bucket 2. For example, lets say the list is people on a bus, and the field indicates if the people go onto bus 1 or bus 2. I want the second worksheet to be a list of only the people on bus 1, and the third worksheet to be the people only on bus 2. I can do this with the advanced filter option. My problem is that if I change the original data on worksheet 1 (lets say switch someone from bus 1 to bus 2 in the original data), I don't know how to get the lists in worksheet 2 and 3 to automatically update with this new information. Is there a better way of doing this other than with the advanced filter? Thank you Mark |
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) |