custome Lottery with raffles

hello there I am trying to create a spread sheet that has in Sheet 1 Column A and Column B with the corresponding titles "Participants" and "Raffles" . The Column A and Column B does not have a fixed amount of participants or raffles , which means in one day there can be 5 participants but in the next day there can be 500 participants . Same happens with Column B.

Now at the cell F1, I have the total number of raffles (the sum of the total ruffles from Column B.

What I want to do is a code that when I have in Column A , for example 3 names FireDragon, Ulothar, Ioana, and the corresponding Values in Column B are : 100, 50, 5 to get the results in Sheet 1

FireDragon 1
FireDragon 2
FireDragon 3
...................
FireDragon 100
Ulothar 101
Ulothar 102
Ulothar 103
......................
Ulothar 150
Ioana 151
Ioana 152
Ioana 153
......................
Ioana 155


I do include a sample file as well to show you what I want

Hi !

with a row header in Sheet2, could be easily achieved without a code just with an advanced filter & formulas.
Of course if really a code is needed just activating the Macro Recorder as a starter …

The other way like Sheet2 is actually : via a Dictionary object …

Hello Marc L

Yes I do need to make a code for it, what you mean to activate the Macro Recorder , I mean I need the macro for it I am confused hehe