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

If you are familiar with macros then
1. Record a macro while performing the steps for Advance Filter
2. Put the code for the recorded macro in the Private Sub Worksheet_Activate()
event of sheet2 and sheet3 after necessary adjustments.

Since you have to do advance filter on the same sheet, you will have to cut
and paste that data to the other sheet while recording the macro...

This way when a user opens sheet2 or sheet3 she will get the latest data in
that sheet...


"mottawa" wrote:

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