I wouldn't have wasted my time answering if I had realised that you had
already asked the question in another thread and got the answer. Please
don't start a new thread in such situations; if you had continued the
previous thread and explained why you weren't happy with the suggestion that
had been made, then you might have stood more chance of getting the answer
you wanted.
--
David Biddulph

"HELPME" wrote in message
...
Ughhhh....lol...I know it can be done this way, but am looking to have it
fill the second table in automatically without having to cut and paste or
copy and paste. The person who will be using this just wants the master
list
of names, and then the second table to populate itself without having to
sort/filter cut and paste, there must be a way for this to work, if a
macro
is needed, i dont know how to do macros, but can learn, it hought a lookup
could be used, but having problems since one list is 60-80 lines going
into a
table that is only 10 lines large. PLEASE HELP

"David Biddulph" wrote:

Select the table of data
Data/ Autofilter
Children/ No
Copy
Paste
--
David Biddulph

"HELPME" wrote in message
...
Ok I tried the auto filter thing, not working the way i need it, here
are
the
specifics again, I have a chart that looks like this on the first
worksheet:

NAME AGE CHILDREN
JOE SMITH 32 YES
DEBBY ALLEN 19 NO
CHRIS JONES 45 YES
TOM WILLIAM 17 YES etc,
etc......

OK this list has about 60-80 names on it....now i have another table on
another page that has enough lines for exactly 10 of these names to be
transfered to, I know that there will be only 10 peole from the list
who
answer NO to the CHILDREN column, so I wan to be able to somehow pull
from
the first list(60 people) and transfer the names of the 10 without kids
to
the spot I have on the second page...is this possible, i tried
sort/filter,
does not do what i need it to do, can i use a lookup somehow??? PLEASE
HELP