Vba

[tlindeman]

Good morning,
Could you please supply me the code to copy paste cell D100, from worksheet "workout" to sheet "improvement" however, I want it to be additiive, in other words I want it to paste into cell A2 the first time, A3 second time, etc.

Thank You

 

[VoG]

Try

Sub Cpy()
Sheets("workout").Range("D100").Copy Destination:=Sheets("improvement").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

 

[tlindeman]

that will work, thank you