VBA timestamp and value check code.

Hello everyone,
I was trying to figure this out, but couldn't on my own, so there is nothing for me else to do but to turn to the pros.
I have this code which copies a template to the bottom of the active sheet from another sheet if a value is entered in column U,
The problem is that the part which checks if it's a new lot number and the entry timestamp, only works if i enter the "Box code" value in the cell where is should be.
To explain it simply if i enter the code in a specific cell, in column U it looks like this:
Untitled1.png
Result: Code is near the "box code:", G32 is marked as NEW, I32 has a timestamp, because the code was entered in U32
If i enter the code anywhere in column U it looks like this:
Untitled1 (1).png
Result: Code is near the "box code:", G6 is not marked NEW, I6 doesn't have a timestamp, but I9 has, because the code was entered in U9.

Sheet code:

Please Login or Register  to view this content.

A part of Module1 code:

Please Login or Register  to view this content.

To put it even more simply:
How to make this:

Please Login or Register  to view this content.

Work after this :

Please Login or Register  to view this content.

Any kind of help and tips are really appreciated.

Original post here:

HTML Code: 

Also posted here:

Please Login or Register  to view this content.

Looking at the code, I think you may be able to add a single line here:

Please Login or Register  to view this content.

WBD

Please attach your workbook and I'll fix it tomorrow for you.

WBD

See attached.

WBD

Strange. It's all working for me in the workbook I uploaded.

WBD

Ah. OK. Change "With Target" to "With r" in the Worksheet_Change code.

WBD