Dynamic reference

[Jabj]

Hi,

I've two different workbooks which are independent on each other.

Workbook 1:

In column D I’ve the country (lets say Denmark for instance).

In Column E I’ve a issuer depending on the country in column D (so from row 8-11 I’ve DK AS for instance and again from 12-14 I’ve OP AS)

In column G I’ve their individual code for each issuer in each country

So my problem is as follows,

I need to write a code so I can make a dynamic reference depending on how many issuer and must important their individual code and copy only the data in column G to another workbook.

For instance I’ll always have 12 different countries but within each country the number of issuer and their individual code can easily change from week to week.

How do I write a code in VBA and is it possible to do this as soon as you open mt workbook 2.

[p24leclerc]

it would be easier to work on this if could attach a workbook.