Userform - Adding Data to Existing Rows

What I currently have working (it's a working progress still to be tweaked) is a Userform for inputting data into relevant rows (inputform).
What I now need and have almost got working is another Userform for adding in some additional information and preferably overwriting any existing data (updateform).

I'm very new to VBA and have been doing my best to get my head around it but can't say I completely understand all the terms, I work with taking existing code I have found elsewhere and editing it to best suit my needs. This means a lot of fiddling to try see exactly what each line of code is doing. With my current task I've about reached my limit and am now well and truly stuck on how to fix this issue. In short, there may be a lot of irrelevant/incorrect lines of code that I haven't realised are irrelevant/incorrect.

So, to the issue in hand.

I will have lots of unique contract numbers (column A) that I will be using to bring up the details in the update form.
I have the client name (column D) which is currently serving as a check to make sure I have brought up the correct contract.
Then I have 7 more boxes to be filled out with the new data that I want added to existing rows (Columns AG,AM,AN,AO,AU,AV,AW)

I have a piece of code that I thought should work but it just adds the data to a new row and I can't seem to figure out why it is doing this or how to get it to instead write in the existing rows. (Update Button)

Please Login or Register  to view this content.

The only thing that I can think of that would be causing this issue (if it's not part of the above code) is the piece of code that brings up the information to begin with. (Find Button)

Please Login or Register  to view this content.

Please let me know if I've missed out any relevant data!

Example attached.

Done, hope that helps.
Thanks for the advice and instructions on how to do so.

I feel like I'm missing something blindingly obvious about the code I've used but can't for the life of me find out why it's still acting up.

Let me guess (didn't test)...
First find last row.
Then find match (I assume Contract).

if match is not found you'll got error.
Because of On Error Resume Next part it will remain on last row.

In other words: it will put data in last row if match is not found.

Please Login or Register  to view this content.

I think this is the problem:

Please Login or Register  to view this content.

You loop through looking for a match with the contract number and, when you get one, you update the client name. However, you then continue to loop through the data to the lastrow ... hence the currentrow will always equal the lastrow. I think you just need to add an Exit Sub when you find the client you are looking for.

Please Login or Register  to view this content.

Regards, TMS

You're welcome. Thanks for the rep.