Data Entry - Userform, override and update data instead of duplicate data.

Hi all,

I hope you Guru's can help a guy trying to help himself.

I currently have a spreadsheet with a VB user form front end that allows staff to enter 'New' customer details when they sign up to our services, this data is automatically put into a separate sheet when they click submit, the sheet has fields such as name, telephone, stand number, etc, etc.

When a new customer is entered it automatically enters this record below the last record in that new sheet.

The way it current works is when they make initial contact with the customer they enter the data, then when the customer is 100% confirmed with us they enter the data again or some of their data and it also added in to the list, the only problem is i end up with duplicated data entries and i would like just the one, most recent entry per customer.

When they enter a modification to the previous 'original' data, via the userform 'modify' or 'delete' button it is automatically put next in line in the sheet. What i would like is that instead of creating a new line of data, essentially duplicated i would like it to modify existing data linked to that stand number 'if it exists' and if not create a NEW data entry for new details. If data already exists i do not want it however to override the current data as a whole, more than just update the fields that have changed, leaving the original unchanged data the same: For Example the change might only be that the stand has got bigger, so in the modify form the user would only really enter the stand number and change the stand size.

I hope this makes sense, i have spent lots of time working on this and i started as a VB beginner, i have uploaded a copy of what i have done and i am working on with all important data removed or changed. The sheet is protected and the password is password.

I hope you experts can help me put the finishing touches to my project.

Mike