Think you have below values in "Sheet1" of your excel workbook. And you want to just copy paste them to similar cells of the "Sheet2". You can do it with one line of code.
Below code will copy values of cells from "A2" to "E2" of sheet1 to same cells of sheet2.
Worksheets("sheet1").Range("A2:E2").Copy Destination:=Worksheets("sheet2").Range("A2") |
