Hi bbibib
You can use advanced filter to do this
http://www.contextures.com/xladvfilter01.html
Or you can use my Filter add-in (very easy)
http://www.rondebruin.nl/easyfilter.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"bbibib" wrote in message ps.com...
Hi there, some assistance if possible.
I have 200 names in column A on a sheet1. Each name can have upto 10
entries.
I would like to reference five names that are on sheet2 and copy the
rows from sheet1 for each name onto sheet3. So I would then have
approx 50 rows with all of the names I require.
Hope someone can help, and understands!!
Many thanks,
Bob.