Use existing table to populate a drop down list & create a new tab

[Guest]

OK, here's a simple version of what I'm trying to do. I have this table set
up on a worksheet:

Name: #: Color:
Andy 1 red
Aaron 2 blue
Allison 1 green
Anthony 2 violet
Abdul 2 azul

I want to create a drop down cell that lets me pick one of the values in the
# column. Then, once I pick that, I want a table created below this drop
down cell that is populated with the names and associated colors from the
above table. So, in this example, my drop down cell would have the options 1
& 2 in it. And if I pick 1, then a table would be created like this:

Andy red
Allison green

I know enough to do this piecewise, but my attempts to get this to work
automatically isn't getting anywhere. Any help would be greatly appreciated.

 

[Dave Peterson]

How about an alternative?

You could select your range and then do data|filter|autofilter.

Then you can use the dropdown to show the values you want.