Why not just use datafilterautofilter

--
Don Guillett
SalesAid Software

"HELPME" wrote in message
...
ok here are the details:

I have a three column table on one sheet, one column with name, another
with
address, and the last is a yes/no only for kids, looks like this:

NAME ADDRESS KIDS
John Smith 2222 River Rd YES
Bob Gillian 101 Main St NO
Susan Wallow 59 N. Peters YES

This table has about 80 rows of different people. Now what im trying to do
is this, I know for a fact that I will have no more than 10 people who
answer
NO to the last column, so i have another table on a different sheet 10
rows
long that i want a list of those with who answer NO put on it. I guess
what
im asking is i want Excel to search this 80 row list for those who answer
NO
and copy their Name to this other page's table....how can i do this?
Thanks
for the help.