Function to get data out of a list using criteria

[sot]

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.

 

[Roger Govier]

Hi

Use Advanced Filter.
Start from a new sheet and enter the word Code in cells A1:C1
In A2 enter P, in B3 enter A and in C4 enter OB
Data>Filter>Advanced Filter>Copy to new location
List Range point to your data source range on Sheet1
Criteria Range Sheet2!$A$1:$C$4
Destination Sheet2!$A$6:$B$6

 

[sot]

Hi Roger
This definately does the job, but I was hoping for a more automated method,
such as a formula as the data in the master list will change frequently and
also the Data being extracted by code needs to be in different sections of
the sheet.?