Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a Row in a sheet based on criteria in another
Hi all,
I have 2 workbooks. The first has a list of string names in Column A (about 40 unique). The second has a large sheet of data based on those names from the first sheet. So each for the 40 names i may have 100 rows of data. Naturally these names are also in Column A of the second workbook, with the data from column B onwards. Basically i would like to do a loop where i look at Column A in the first workbook starting from A1, taking the activecell value and then going to the second workbook and copy each row where Column A contains the activecell value from the first. Then this would be pasted into a 3rd workbook. And continue this until the 40 names in the first workbook are exhausted. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a Row in a sheet based on criteria in another
Hi Nab,
Perhaps you could adapt the techniques employed by Ron de Bruin at: Copy records with the same value in a column to a new sheet or workbook http://www.rondebruin.nl/copy5.htm --- Regards. Norman "nab" wrote in message ... Hi all, I have 2 workbooks. The first has a list of string names in Column A (about 40 unique). The second has a large sheet of data based on those names from the first sheet. So each for the 40 names i may have 100 rows of data. Naturally these names are also in Column A of the second workbook, with the data from column B onwards. Basically i would like to do a loop where i look at Column A in the first workbook starting from A1, taking the activecell value and then going to the second workbook and copy each row where Column A contains the activecell value from the first. Then this would be pasted into a 3rd workbook. And continue this until the 40 names in the first workbook are exhausted. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying whole row to another sheet based on criteria on cell | Excel Discussion (Misc queries) | |||
Copying from one TAB to another based on certain criteria | New Users to Excel | |||
Copying line from one sheet to another based on given criteria | Excel Worksheet Functions | |||
Copying a range based on criteria | Excel Programming | |||
Copying whole rows based upon one criteria | Excel Discussion (Misc queries) |