Create key for multiple records to identify which ones are clones?

[TheWennerWoman]

Apologies for the vague title.

I have a blank worksheet. In cell A2 there is "New record" - double-clicking on it launches a blank userform. The user completes the form, clicks "submit", row 2 populates with the data entered and "New record" changes to "Edit record". If the user double clicks "Edit record", the form launches with the previously entered data.

Cell A3 then contains "New record".

This all works perfectly.

If there is more than one row for a person (say a customer with multiple orders), a lot of the information entered (name, address, date of birth etc) is the same and I've been asked if it's possible to clone that detail to avoid having to enter it many times. I've added a "clone record" tickbox to the form so that bit is easy.

However, and this is the nasty bit, if someone wants to edit a record (say they misspelt the street address) and that record is one of the cloned records for that customer, every single cloned record needs to be updated.

I've been toying with the idea of creating a hashkey based on some of the data entered but, of course, if some of it is edited then the hashkey will change.

Any thoughts on the best way to attack this?

Many thanks for reading.