is it possible to auto create many records

[ccarpe17]

I have a excel sheet with a series of random numbers, for each cell in this series I need it to create a series of numbers in a second sheet based on a single cell in the series in the first sheet. For example if a cell in first sheet is 144;I would like to create 144 new rows on second sheet; So I want to create a series 1-144 based on that 1 cell in first sheet. This would need to be repeated on every cell in the first sheets series though.

 

[ranman256]

get the 1st number in cell 1 and run for 143 more cells

sub Numberize()
iNum = range("A1").value
range("A2").select

for r = 2 to 144
   iNum = iNum  + 1
   activecell.value = iNum

   activecell.offset(1,0).select  'next row
next
end sub