How to multiply data ?

[kerplunk]

Dear all,
Greeting!!

Thx in advance for your kind help..

I have prob here..

How i want to multiply the data when..
A1-200
B1-4
..then it multiply become...
C1-200
C2-200
C3-200
C4-200

..it's meant the column C is multiply of A1 data based on number in B1
..and the C column keep multiply downward..

Your kind help is indeed helpfull since I working as a data entry..
Thank you so much for helping me..

regards,
Wan

 

[JackDanIce]

Welcome to the board, a macro can do what you want.
Try:

Sub RepeatingIterations ()
 
With Application
    .ScreenUpdating = False
    .Calculation = xlCalculationManual
End With

If Range("B1") > 0 Then
    Range("C1").Resize(Range("B1"), 1) = Range("A1")
Else
    MsgBox "Please check cell B1 contains a positive integer"
    Range("C1:C" & Range("C" & Rows.Count).End(xlUp).row).ClearContents
End If
 

With Application
    .ScreenUpdating = True
    .Calculation = xlCalculationAutomatic
End With

End Sub