Show a subset of Sheet A on Sheet B

[AnneM]

I need to copy a subset of sheet A to Sheet B based on the value in column R on sheet A. How

Sheet A is a list of all team members with their work group identified as column R = Y if they are in Group A
Sheet B is a subset of those in the whole list who are in Group A

Thanks.

 

[Aladin Akyurek]

One way is to use Advanced Filter with computed criteria.

I need to copy a subset of sheet A to Sheet B based on the value in column R on sheet A. How?

Sheet A is a list of all team members with their work group identified as

column R = Y if they are in Group A.

 

[AnneM]

Thanks, I thought of that, but I want something that will update each Sheet if I correct a name or phone number on the master list. I'm thinking a Lookup is the way to go: nested in an IF statement on the group column. But???? Filter will always work. Thanks.

 

[AnneM]

OHH, now I get it. Yes that works. Thanks. I think a =Sheet B!A2 and a regular filter will work also.

 

[Aladin Akyurek]

Glad to hear that.

OHH, now I get it. Yes that works. Thanks. I think a =Sheet B!A2 and a

regular filter will work also.