Macros for inserting row if condition applies in different worksheet

Hi guys,

I am totally new to Macros and would greatly appreciate your help.

I need to write a macros code that inserts a row in one worksheet based on several conditions being satisfied in a different worksheet.

Let me describe it to you in more detail and hopefully make it as simple as possible:
There is a list of countries in worksheet A. Worksheet B contains a list with country descriptions. The macros would have to go through Worksheet B, and insert separate rows inside Worksheet A with the descriptions from worksheet B (say ColumnA in worksheet B contains the country name and Column B the country description).

Is this possible at all? Having something like a "Refresh Data" Button that in Worksheet A that does that?

Many thanks in advance and am really sorry if it sounds convoluted. Hope there is a solution for this.

Florin

Hi Florinnn

The code below should provide you with a solution to your problem. It does need for you to create a name 'Desc' which covers the country name and description on the second worksheet. Also the current code is only looking at values in column A rows 2 to 10.

Please Login or Register  to view this content.

I hope it helps