software

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.Hi bbibib

You can use advanced filter to do this
www.contextures.com/xladvfilter01.html

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

Does a fantastic job, and more!!

Thanks again.gt; Wow - what an add-in.
gt; Does a fantastic job, and more!!

Thanks--
Regards Ron de Bruin
www.rondebruin.nlquot;bbibibquot; gt; wrote in message oups.com...
gt; Wow - what an add-in.
gt;
gt; Does a fantastic job, and more!!
gt;
gt; Thanks again.
gt;