Automatic Data Sorting

[BenjieLop]

I am wondering if there is an Excel formula for this problem of mine.

All necessary/required data will be entered on Sheet 1 and the "sorte
data" will be in either Sheet 2 or Sheet 3.

Here are the given data (on Sheet 1):

NAME CODE
Smith 123
Jones 456
Ashby 123
Aaron 123
Brown 456
Kalvin 456

I need to sort the data according to the CODE. In other words, I woul
like to have all names with code=123 to be automatically entered o
Sheet 2.

Sheet 2 (column A) entries will look like this:

Smith
Ashby
Aaron

In the same token, I would like to have all the names with code=45
automatically entered on Sheet 3. Similarly, column A of Sheet 3 wil
look like this:

Jones
Brown
Kalvin

Thanks in advance for any help

 

[Don Guillett]

Have a look at data>filter>autofilter