Macro to generate a list of values

Hi All,

I hope someone can help.

I am trying to set-up a macro the process our "Link" and "Class" data to produce all full pick-list of all possible "Link and Class" variations.

I have attached an example file which shows the original data in Column A & Column B and the output i am looking for Column D and Column E (Highlighted in green).

The main thing is that the number of values/records in Column A and Column B varies sheet to sheet.

Hopefully someone can assist, if i havent explained it too well please feel free to contact me.

Many thanks in advance.

Gary