Hi,

I have a spreadsheet with a list of 500 names. Their surname is in A1 and
firstname in B1. In column D, I have a number down the column for each person
that represents the number of tickets each person receives in a prize draw.
Some people have 1 ticket, others two, others three or four and so on.

So the data looks like this:

A B C D E
Smith Bill 2
Jones Karen 5
Travis Jo 0
Smith Jess 1

If a person has a 2 (representing two tickets) in cell D1 (as above) then I
would like their first and last name to be printed twice - once in cell A1
and again in cell A2 of the next worksheet called "draw". If the next person
has five tickets I would like their name printed five times: in A3, A4, A5,
A6 and A7 underneath. If the third person has no tickets, then their name
would not appear on the second worksheet ("draw"). This process would
continue through the 500 names in the first worksheet. Not all people would
have a ticket so their name would not appear in the "draw" worksheet. And a
person who has a 10 in the D column would have their name listed ten times in
the "draw" worksheet.

Is what I want possible and can I add code to a button on the first worksheet
to automatically do this?

Many thanks
Anthony

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200711/1