Update&Modify excel Database

[surya9]

Hi All
I have an excel sheet where I am trying to make database. In the first(Entry) sheet the person enters the data and submits. The same is added in the second (Database) sheet with the first two columns is added by default in the database sheet. I have the code for the same.

Now, I want excel to have a search box in the sheet 1 and when the person enters the Emp ID, excel should validate the username, if the username is matching with the current user, it must display the all the field back in the sheet 1 from sheet 2 for editing and resubmitting. When resubmitted the current record must overwrite previous record.

If the username name does not match then user must not be able to view the data.( this is just to keep other people’s data confidential).

Also in the sheet 2 I need the headers based on the sheet 1 fields (This is not mandatory. I can enter them as a onetime activity)

Request someone to help me…
Attached is the excel sheet temaplate and code

Thank you in anticipation