Making a list off of criteria in another sheet?

  • Thread starter Thread starter Ted
  • Start date Start date
T

Ted

I have a worksheet with a list of data in column C. Each item in
column C belongs to one of three groups, currently listed in column D
(but could be moved to another column if needed) For example:

Tom Group C
Bob Group A
Carol Group B
Joan Group A
Harry Group B
David Group A
Mike Group C

What I would like to be able to do is, on another worksheet, have a
list of only the people in group A, on another worksheet the people in
group C, etc. The groups could change quite often so I'd like this to
update automatically. So far I haven't been able to find a way to do
it. Any help would be appreciated.

Ted
 
Why not just stay where you are and use
Data>filter>autofilter>filter by desired group
 
Back
Top