I have an Excel spreadsheet that acts as a customer database. Basic data entry (5 fields) is via a userform.
I am looking for someone who can add 2 bits of functionality
1. When data is entered into the first field of the form (Co Name), this is compared to existing records to see if record already exists.
a) If no matches found, other 4 data fields can be completed and data added to database
b) If matches are found, these are displayed (all 5 fields) one at a time by use of a "next button" for user to identify the company by visually checking the other fields, User then has the choice to add a record with same "Co Name" but with new info for the 4 other fields OR clears all fields and starts with a new Co Name
2. When new data is added to the database, a unique ID code is generated for each record