'Looping values from specific cell to a column in Excel

I would like to have a macro in which by providing a value in cell E3, the value of E3 is copied and pasted in cell K17. Then I will modify the value in E3 to populate cell K18, and so on and so forth.

This is the current code I have, but of course it's limiting me to add the desired value from cell E3 to be always pasted in cell K17:

Sub box_value()
    Range("E3").Select
    Selection.Copy
    Range("K17").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("D5:D10").Select
    Application.CutCopyMode = False
    Selection.ClearContents
    Range("K18").Select
End Sub

Final result in excel:

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Looping values from specific cell to a column in Excel

Sources

Related Questions