Code not finding unique number causing duplication of data

[peter renton]

Hi
I have attached a small wb

when the data is entered on sheet one and the macro is activated (i need this to be automatic but i will start a need thresd for this)
the selected data is coppied over into the master sheet, it should be checking if the reg has already been copied and if so only update
any changes into that row..what is doing is just adding another line (it was working) reg format would be letters and numbers.

I need sheet 2 used contracts to also copy data to the master sheet how do i add to the exsiting code to do that???


any help would be appreciated


regards


Peter

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg. A0opm95t2XEA0q3KshmuuY
https://www.youtube.com/watch?v=bRd4mJglWiM&lc=UgxRmh2gFhpmHNnPemR4AaABAg
https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314619#p314619
https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314600#p314600
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA