Hi Gurus,

I have no knowledge related to VBA or marcos. I need help how to change this condition:

before:
Sheet1
User Count of Roles
Jamie 3
Rosie 2


Sheet2
User Roles
Jamie Marketing
Jamie Accounting
Jamie Sales
Jamie Marketing
Jamie Accounting
Jamie Sales


after:
Sheet2
User Roles
Jamie Marketing
Jamie Accounting
Jamie Sales
Jamie Marketing
Jamie Accounting
Jamie Sales
Jamie Marketing
Jamie Accounting
Jamie Sales
Rosie Developer
Rosie System Tester
Rosie Developer
Rosie System Tester


Basically, I want to copy list of roles n times, where n is amount of roles. For example, Jamie have 3 roles: Accounting, Sales and Marketing. Therefore roles in sheet 2 for user Jamie will be copied three times.

Thank you for your help.

Thanks,
Kris