Two Lists Join - But 1st list is index and 2nd list repeats

Scenario

List 1 - 5 Usernames (Sheet 1)

List 2 - 3 Stock Items (Sheet 2)

I need to join the 2 lists however for every Username (List1) I need to show all Stock Items (List 2) all to be displayed on Sheet 3.

Sample Output:

User 1, Item 1
User 1, Item 2
User 1, Item 3
User 2, Item 1
.......
.......
User 5, Item 3

Can you advise how best to achieve this via VBA?

I know to set the range and cycle through the Usernames - but don't know how to then action this and copy and paste the data onto a new sheet.

Hi Brad,
try

Please Login or Register  to view this content.

Hi nilem,

Thanks for the prompt response. Looks like it is working! Fantastic.

One final tweak....

If I expand the Lists can this also work?

List 1 - Username & email (Sheet 1: column A & B)
List 2 - Item & qty (Sheet 2: column A & B)

Sample Output:

User 1, [email protected], Item 1, 1
User 1, [email protected], Item 2, 2
......
User 5, [email protected], Item 5, 5

Please Login or Register  to view this content.

Perfect - thanks nilem!

You are welcome!