Maybe you can apply Data|Filter|autofilter, show the rows with No in that
field. Then copy those visible rows to the other sheet???

HELPME wrote:

Because the table that the names get copied onto on the second page is part
of a page that i need printed out with just those who answered NO, so i need
those 10 names separated and copied over to a different table, can autofilter
be used for this purpose? Thank you for your help with this

"Don Guillett" wrote:

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.




--

Dave Peterson