I have created my first userform, simply it look up a provider name from a list and pre-fill some information then we fill the rest of the form, if the provider is an MG the data is populated in the MG sheet else MP sheet.
The provider could be entered many times for different records.
My question is that:
Using the form or (another form for Lookup and update) I would like to ADD a button so that someone can enter the provider's name and look up the record(s) that are already have been entered in the past in either sheet "MG" or sheet "MP" so that it could be corrected or to enter more fields that was left empty the first time the record was entered, so simply update already existing records using the form. Please note that when someone looks up the provider's name there may have been several records for this provider, so I need to have a mechanism to search through the multiple records for the provider to find the one record that I need to modify and update.
I am attaching my file.
Thank you
Bookmarks