Getting the amend function/code to work correctly

Hi can anybody help me to solve this problem, it has bee driving me mad over the last few days.

I have started to build a user form that (will) allow myself to update a database at various stages of our projects. everything seems to be working apart from the update/amend function. When i search for a project and make any amendments as soon as i hit the update button it copies it to a completely random cell and doesnot overwrite the existing row.

I have attached the files, it would be great if someone could take a look and help me, i am new to VBA so not quite with it yet.

Thanks guys/girls