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.