Code to copy from one sheet to other not working properly

Hi I have below code which was brilliant help from Mumps1 in this forum. What i did not think about was that it has to be changed to the need in the real worksheet. I thought i could do easily, but it dont work-.
The code i got compare a number in column B sheet2 with column B in sheet3 , if there is a match it overwrite the row in Sheet3. If there is a new number in sheet2 column B the it add this row to the last last used row in sheet 3. All good and the code was working. And fast also which is important- In the test sheet there was 6 columns, but in the real sheet there is columns from A to AJ all if i count correctly 37 columns.
I have tried change below code to the amount of columns but it dont work. It will not copy all the columns mostly just the same 5 as before.

First is the code Mumps1 helped me with work fine for column A to F
And after that the code i tried but not working.

I have attached a test sheet with all columns now.
So if time please have a look thanks.
Sincerely
Abjac

Please Login or Register  to view this content.

And this is what i tried but not working,

Please Login or Register  to view this content.

Hi davesexcel. The code i provided did not copy if there was a change in the cells in sheet2 not after column E-
Mumps1. You did it again. The code is with the little change work perfectly. So thanks alot. I will mark it as solved. But would be nice if you could
explain what these numbers do and refer to example Item:=i + 6. Because to be honest dont really understand it totally. When i tried change the code. I had doubt about this. But thanks allot really great help again.
Sincerely
abjac

Originally Posted by Mumps1

Please Login or Register  to view this content.

Each unique value in column B of Sheet2 is stored in rngList as the Key and the Item stores the row number for each value. Since your data starts in row 7, the row number would be calculated by adding 6 to the value of "i". If "i" is 1 then the row number is i + 6 which calculates to 7 and so on. This row number is then used to paste the data in the correct row in Sheet3. I hope this makes sense.

HI yes I understand this now. Which is good way. The code is fast. Thanks for the explanation and help
Sincerely
abjac