Dear Friends,
We have a new data entry operator who will be entering all the new employee data in a spreadsheet. We need to build a template for this person as he is a fresher to MS Excel.
Seeking your help to construct the template on below example.
Kindly help.
We have a new data entry operator who will be entering all the new employee data in a spreadsheet. We need to build a template for this person as he is a fresher to MS Excel.
Seeking your help to construct the template on below example.
- We have built 2 worksheets - 1. Master (for Data entry); 2. Datalist (List of all other Masters).
- Most of the columns are drop down list (Data validation list) from the Datalist sheet.
- In Master sheet, there is a column with drop down list of employee type (Worker & Staff), which will be first selected.
- Based on the selection, column with drop down list of Designation should display only designations under that perticular type.
- Most of the other columns have drop down list which are dependent on the type selected.
Kindly help.
Last edited: