Code for copy rows from sheet2 to cheet1

[Bengan]

I wonder how to copy values from sheet2 raw 4 column A, to sheet 1 row 4 column A.
I will update the values form sheet2 to sheet1 with a button and want it to overwrite sheet1 everytime I uppdate.
The range is between A4 to A299.

PLEASE HELP
Bengt from Sweden

 

[Michael M]

So you want to copy every row from 4 to 299 from sheet 2 to sheet 1 ?
Is it only the values or are there formulas involved as well ?

 

[Michael M]

Maybe one of these
This one will copy the entire row

Sub MM1()
Sheets("Sheet2").Rows("4:299").Copy Sheets("Sheet1").Rows("4:4")
End Sub

While this one will only copy column "A"

Sub MM1()
Sheets("Sheet2").Range("A4:A299").Copy Sheets("Sheet1").Range("A4")
End Sub

 

[Bengan]

Many thanks from Sweden. Best regards Bengt

 

[RoryA]

Please take a minute to read the forum rules on cross-posting and follow them, especially as you seem to be doing it with every post. Thanks.