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

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" <(E-Mail Removed)> wrote in message
news:25B47973-0F1A-4F3B-BDDF-(E-Mail Removed)...
> 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