Afternoon all. A friend asked me to help with her spreadsheet but this ones got me stumped.
The sheet is a list of names in column A, in column B is the number of raffle tickets they have.What im trying to do via VBA is look at the first name in the column and duplicate that entry to the next lines depending on how many tickets that person has. Then go to the next name and continue until there are no further entries.
The first rows in the attachment shows the 'Raw' data. Row 8 onwards shows what im wanting it to look like when finished. I did find some code during a search that could look at the date and then insert that many rows; but not copy the data to each row.
Eventually each entry will be numbered from 1 to (Total tickets) and then a random number generator used.
Many thanks for any help available
Bookmarks