transfer data sheet1 to sheet2 VBA problem

hi, I am really novices in VBA. Hopefully someone can help me to solve my problem.

I take this vba code from some where in youtube.

I try to copy and paste specific Worksheet Range Data from "Sheet1" to "Sheet2" based on condition in "Sheet2" which is if the
"Sheet2" has the same id number then it will be paste in spesific range of data only.

This is the coding, but it cannot transfer the data. I don't know why. May be my friend here can give me the idea how to improve the coding.
Thank you very much.
--------------------

Please Login or Register  to view this content.

--------------------
TRANSFER sheets1 to sheets2 Sample.xlsm

regard,
habib

Hi habib, thanks for adding the code tags. My answer is 2 part:

The reason your code does nothing is that this line:

Please Login or Register  to view this content.

sets "lasrow2", but your loop is 2 to lastrow2 (which is 0)

But I also wanted to mention that if the data set is big, doing a double loop could take longer than something like this:

Please Login or Register  to view this content.

Originally Posted by Arkadi

The reason your code does nothing is that this line:

Please Login or Register  to view this content.

sets "lasrow", but your loop is 2 to lastrow2 (which is 0)

I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors. If Option Explicit were used here, this error would have been flagged by the compiler.

Very good point @6StringJazzer! I forgot to point that part out, but use it most of the time (I do forget once in a while).