I have a list on one sheet which is essentially a list of names with a group
code allocated to them in the first column. ie column A has in P, OB, A etc
Column B has a name. The group code is not unique to one item so there maybe
6 P's etc. In a seperate sheet I wanted to create a list of all the items
from the first sheet allocated to Group P or group A or Group OB.

Any help, greatfully received.