Code overwrite when copy row but need also to add a new row.

[abjac]

Hi I have below code which work fine. It update in sheet3. So if there is a match in the numbers in Column B sheet2 with Column B sheet3 it copy the row and overwrite the new info in Sheet 3, in the row with the same number.. That is all good. But i need the code also if it dont find a match. Means the number in Column B Sheet2 is not in Sheet3 i would like it to copy this row to the last row in sheet 3 . As a new row. Please if have a look at below code and how do i add the last function in this code.
Thanks in advance.
Sincerely
Abjac

My present code for overwrite.

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[abjac]

HI Mumps1 and thanks for the answer. The code just tried not working. It run nearly 10 seconds and the outfall is that it copy over the row in B7 Sheet3
I tried change example name in Sheet2 column C but it dont copy over. The first code find the match and overwrite the row in Sheet3.- Which is good. I made a line in Sheet2 with id Company id number in Column B38 but its not working. I need when it find the match, it has to overwrite the rows with same id number in column B both sheets, so overwrite in Sheet3. just like the first code do and then after if no match for the Company id number, it has to copy this row over in the first free row from the buttom in Sheet3 I attached a test sheet you can play with also.
Try have a look and maybe send a working sheet back.
Sincerely Abjac

[Mumps1]

Try this version. It uses arrays to speed data processing. If you have a very large data set, looping will be very slow.

Please Login or Register  to view this content.

[abjac]

Hi Mumps1 . I just checked it it works what ever i try. If i change it over write. If new rows with new company id number it add them. This code is just brilliant and really usefull for me- Thanks alot- very appriciated.
Sincerely Abjac

[Mumps1]

You are very welcome.