Search existing and add non existing records in datebase

Hi,

I'm just new in this forum and just starting to learn excel.

I'd like to ask some questions that some of you might find easy to answer.

I'm managing a number of people say 120 employees and i'd like to track their record. For example,

First page would be an input box to type in a name or employee number and hitting enter would bring you to the second page which is either:

A) will return a "No record found, would you like to create a new record?" which has an input box that would only accept either "Y" or "N" input. "Y" command would bring you to a new excel sheet which has an employee record template that includes a name, DOB, employee number (which is what is needed on the first page) and "N" command would bring you to the first page again.

B) will search another excel database and gives you the complete and existing record that includes every detail of that employee and will also give you an option if you want to add a new record like another sanction or disciplinary action.

It's basically a tracker to search employee by name or employee number and would give you all the employee details including their violations, sanctions, merits, etc. and would also let you add a new record for those who doesn't have a record yet and add a new detail to those who already have a records.

I would love to see some sample.

I would really appreciate your help.

thank you so much.

It is not a difficult problem. You should make a sample file and attach it.
Because nobody have much time to make a file and describe everything.

Attach sample file and then you will see the result.

Hi Amirsoft,

Thank you for the tip. another problem is i don't even know where to start. But i'll do my very best to come up with a sample and show it to you, maybe from there it will be easier for you and other contributors to tweak or describe what would be the problem and how to fix it.

Thanks,