Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Copy Data query
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Copy Data query
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Copy Data query
Wow - what an add-in.
Does a fantastic job, and more!! Thanks again. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find & Copy Data query
Wow - what an add-in.
Does a fantastic job, and more!! Thanks -- Regards Ron de Bruin http://www.rondebruin.nl "bbibib" wrote in message oups.com... Wow - what an add-in. Does a fantastic job, and more!! Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Can Excel Find and Copy a row of data? | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) |