VBA- copy and paste

[Nani520]

Hi All,

need some help here. Appreciate if anyone can help to build a Macro to copy data from Sheet1 and paste into Sheet2.
Sheet2 Column H to Sheet1 Column D
Sheet2 Column I to Sheet1 Column F
Sheet2 Column J to Sheet1 Column H
Sheet2 Column K to Sheet1 Column I

Thanks in advance!!!

Sheet 1:

Sheet 2:

 

[PeteWright]

Do you really need a Macro?
You could simply assign the data from sheet 2 to sheet 1 like this

in Sheet 1: D2 = Sheet2!H7
in Sheet 1: F2 = Sheet2!I7
in Sheet 1: H2 = Sheet2!J7
in Sheet 1: I2 = Sheet2!K7

If you still need a macro, let me know

 

[Nani520]

Do you really need a Macro?
You could simply assign the data from sheet 2 to sheet 1 like this

in Sheet 1: D2 = Sheet2!H7
in Sheet 1: F2 = Sheet2!I7
in Sheet 1: H2 = Sheet2!J7
in Sheet 1: I2 = Sheet2!K7

If you still need a macro, let me know

yaya and following the number in column A, possible to do that?

 

[PeteWright]

Should be:

Sheet 1: G2 = Sheet2!A7