Pulling specific data from a sheet
 

The sheet I am working with has a column of ~150 names (A2:A151). A1
has the title "Names".
The 27 cells to the right of A1 (A1:A28) all have their own name based
on specific criteria.
If the person in column A meets any of the criterea an X is placed in
that cell. So Name A2 might have A3,A4,A7,A20 all filled in with an X
with the rest of the cells blank.

What I need to do is break the names into lists based on whether they
meet one or more of the criteria. So if the name of column B1 is
"Likes Dogs" I want to have a list created elsewhere of every name in
the spreadsheet that has an X in that column. I need to make a list
like that for every criteria on the sheet.

What I also need to do is to create lists based on multiple criteria.
So if B1 is "Likes Dogs", C1 is "Likes Cats" and G1 is "Takes Long
Naps" I might need a list of all people on the sheet that have an X
under all three.

I have done a lot of If statements and other formulas as well as some
minor VBA - but this process has eluded me so far. Any help or
direction is greatly appreciated.

Pulling specific data from a sheet
 

m,

You can use Autofilter on your table, filtering a column for X, then copy/pasting the names
to one of the lists you want. Or you can set up an advanced filter for each one (Data -
Filter - Advanced filter). You can also achieve your second objective with eigher of these
methods. Either of these is a manual process, automateable (?) with a macro.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"mCassidy" wrote in message
oups.com...
The sheet I am working with has a column of ~150 names (A2:A151). A1
has the title "Names".
The 27 cells to the right of A1 (A1:A28) all have their own name based
on specific criteria.
If the person in column A meets any of the criterea an X is placed in
that cell. So Name A2 might have A3,A4,A7,A20 all filled in with an X
with the rest of the cells blank.

What I need to do is break the names into lists based on whether they
meet one or more of the criteria. So if the name of column B1 is
"Likes Dogs" I want to have a list created elsewhere of every name in
the spreadsheet that has an X in that column. I need to make a list
like that for every criteria on the sheet.

What I also need to do is to create lists based on multiple criteria.
So if B1 is "Likes Dogs", C1 is "Likes Cats" and G1 is "Takes Long
Naps" I might need a list of all people on the sheet that have an X
under all three.

I have done a lot of If statements and other formulas as well as some
minor VBA - but this process has eluded me so far. Any help or
direction is greatly appreciated.

Pulling specific data from a sheet
 

On Sep 21, 9:10 pm, "Earl Kiosterud" wrote:
m,

You can use Autofilter on your table, filtering a column for X, then copy/pasting the names
to one of the lists you want. Or you can set up an advanced filter for each one (Data -
Filter - Advanced filter). You can also achieve your second objective with eigher of these
methods. Either of these is a manual process, automateable (?) with a macro.
--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------"mCassidy" wrote in message

oups.com...

The sheet I am working with has a column of ~150 names (A2:A151). A1
has the title "Names".
The 27 cells to the right of A1 (A1:A28) all have their own name based
on specific criteria.
If the person in column A meets any of the criterea an X is placed in
that cell. So Name A2 might have A3,A4,A7,A20 all filled in with an X
with the rest of the cells blank.

What I need to do is break the names into lists based on whether they
meet one or more of the criteria. So if the name of column B1 is
"Likes Dogs" I want to have a list created elsewhere of every name in
the spreadsheet that has an X in that column. I need to make a list
like that for every criteria on the sheet.

What I also need to do is to create lists based on multiple criteria.
So if B1 is "Likes Dogs", C1 is "Likes Cats" and G1 is "Takes Long
Naps" I might need a list of all people on the sheet that have an X
under all three.

I have done a lot of If statements and other formulas as well as some
minor VBA - but this process has eluded me so far. Any help or
direction is greatly appreciated.

Interesting.. thanks for that information. I will definitely do more
research there.
Could this be applied to a sheet to get all of the filtered results..
and then delete all of the original data and copy in a new set of
names and x's when needed to get a new set of filtered results
automatically? Or is this something that needs to be set up fresh
with every new set of data?