Use a specific cell reference to find and overwrite that row(Find and Copy).

I have a form that is used for the user to update a record, and i am struggling to get it to find the search referenced value and select the Cell on the master data set that contains that value.

ie: D7="A1234"
It should find "A1234"
Paste and overwrite the row where "A1234" is the present in column B, Column "A".

The paste bit works it just pastes in the wrong place in the middle of no where so the search is not working.

Cell search reference= Sheets("Ammend").Range("D7")
Search Range: Sheets("Cranes").Range("B7:B500")

The main bit

Please Login or Register  to view this content.

It is the Ammend_FindRow that isnt working as below:

Please Login or Register  to view this content.

Thanks