Table Question

Originally Posted by Wozniak

I'm trying to create 3 tables that populate themselves as the data in the "master table" changes. I'm trying to use vlookup, but since the master changes, it goes out of order.

The table has previously been sorted alphabetically. Three different people are choosing items from this table. I indicate who chose a particular item in the column next to it. From this table, I want to create a seperate table for each person that shows only what the person has chosen.

A simplified example:

Master table:
Apple - Joe
Banana - Mary
Cherry - Joe
Pear -Peter

Joe picked:
Apple
Cherry

Mary picked:
Banana

Peter picked:
Pear


I'd hate to have to move to a database in order to do this, so I'd really appreciate any help. Thanks!

Hi
see the attached file.

Originally Posted by Wozniak

Thanks Starguy! I knew a simple question like this would have a simple answer!

you're welcome
pleased that you're done.