Show a subset of Sheet A on Sheet B

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
One way is to use Advanced Filter with computed criteria.

AnneM said:
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
Click to expand...
column R = Y if they are in Group A.
 
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.
 
OHH, now I get it. Yes that works. Thanks. I think a =Sheet B!A2 and a regular filter will work also.
 
Back
Top