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.