Dim i As Integer
Sub addNewInfo(ByVal stext As String, ByVal icount As String)
Worksheets("Sheet2").Activate
Dim rowcount As Integer
Dim j, m As Integer
j = Val(icount)
rowcount = ActiveSheet.UsedRange.Rows.Count
For m = 0 To j
ActiveSheet.Cells(rowcount, 1).Value = stext
rowcount = rowcount + 1
Next
End Sub
Private Sub CommandButton1_Click()
Worksheets("Sheet1").Activate
Dim rowcount As Integer
Dim stext, icount As String
icount = 0
rowcount = ActiveSheet.UsedRange.Rows.Count
For i = 2 To rowcount
Worksheets("Sheet1").Activate
stext = ActiveSheet.Cells(i, 1).Value
icount = ActiveSheet.Cells(i, 2).Value
Call addNewInfo(stext, icount)
Next
End Sub