Enter and Record/Save data in excel form for multiple entries

[nikx1]

Hi,

I need to create an excel workbook where I can systematically enter and record the details of employee as described below. I will be really thankful for any help on this.

1) On Sheet 1, I have a list of employees and I would select the employee name from a dropdown list using a Combo Box.

2) On Sheet 2, Sheet 3 and Sheet 4, I would enter the details of employee. (The details of all the employees need to be entered in these three worksheets only)

3) After the details are entered, I need to record these details either in the same excel file or a MS Access whichever is the better option.

4) I need to generate a report on Sheet 5 which is an outcome based on the entries done on Sheet 2, Sheet 3 and Sheet 4.

I need to carry out the same process as mentioned above from point 1 to point 4 for entering and recording the employee details and generating reports of all the employees.

Further I would like to select the name of the employee on Sheet 1 and view the previously entered value on Sheet 2, Sheet 3 and Sheet 4 and would like to edit the entries wherever required and again save/update these records in the data base.

The worksheet and workbook needs to be in protected mode. Kindly let me know if there is any solution for this requirement.

Thanks for your kind help.

Regards,

Nikx