Showing Names

[dream]

Hello there, i am running a contest and i have a list of names an
number of eligible tickets. i am running a stats package that wil
generate the number by selecting the row number.
so what i have is the following:

name eligible tickets
joe smith 2
jon doe 5

and this is what i want ....is there some formula that excel can do s
i can get the following?

joe smith
joe smith
jon doe
jon doe
jon doe
jon doe
jon do

 

[Don Guillett]

try this.
Sub dotickets()
For Each c In Range("a2:a3")
x = Cells(Rows.Count, "c").End(xlUp).Row
Range(Cells(x, "c"), Cells(x + c.Offset(, 1), "c")) = c
Next
End Sub

 

[Dave Hawley]

Hi

Could you perhaps use one of these methods?

http://www.ozgrid.com/Excel/excel-random-pick.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[dream]

thanks. it works for the first entry but any other names, i run into an
error highlighting line 4.
i have updated line 2, to reflect the list of names and eligible
tickets so instead of a2:a3 its a1:b11
any insight why its not working?
thanks again