Macro to list numbers


I have a column of numbers say 1 to 10 in column A
In column B at various rows there could be a number. This is the number
of times I need the number in column A repeated in column C eg.
"A2 to A20" have the numbers 1 to 19
if "A3"has the number 2 and "B3" has the number 4 then "C2 to C5"
should have number 2 in them. If the next number in column "B" was say
"B8" and this was 1 then "C6" would be 7

I have been trying to write a macro for this. I have got as far as
going down column A and identifying how many rows are populated and
then got stuck.
Help would be appreciated


--
tryer
------------------------------------------------------------------------
tryer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16546
View this thread: http://www.excelforum.com/showthread.php?threadid=397592

.