Filtering a list

[Linda]

Hi,
Thanks for reading this. Hopefully there is a much
simpler solution then what I have been trying.

I have a customer type: ex. (Buyer, Seller, etc.)
I have the actual customer names: (Joe, Sally, Tim, Jan)

in a list like this:
Buyer Joe 1CedarSt
Buyer Sally 2ElmSt
Seller Tim 3OakSt
Seller Jan 4PineSt

I'm trying to filter out first, whether the customer is a
buyer or seller, then based on that filter list the
customer names and allow the selection of that name to
bring up the address in this format.

Joe
1CedarSt

I can't seem to filter the list of customer names, based
on the filter for whether it's a buyer or a seller.
Thanks

 

[Peo Sjoblom]

Use data>autofilter, it will give you the lists you want but it won't give
you the format
of

name
address

you would need to copy and paste to do that.

why you can't use

name address
joe 1CedarSt