The Year column has more data below, I could not take the full screenshot because of space. Check the named ranges in the downloaded file if you want. You can see the named ranges in the top left of this image.
In case you are wondering what’s in Sheet2, here’s an image of it. If you want to put more data, you can use a similar formula or named ranges or a Data Validation list. This will return the Department of your supervisor based on his name. The formula has some named ranges Part_Timer, Full_Timer, and Contractual which you can find in Sheet2 of the workbook. Now type the following formula in cell B7 and press ENTER.Similarly, we created a Data Validation list for the Service Duration of the employees.Keep in mind that we used a named range for the year from Sheet2. After that, create another list for the Year of Birth.Select List from the Allow: section and type the Statuses in the Source.To create the list, go to Data > Data Validation. First, we are making a list for the Employee Status.Now we are going to create some Data Validation lists.Put them in the name column same as the above picture.To insert them, go to Developer > Insert > Check Box icon from Form Control. You can see that the image contains some Check Boxes.You can insert rows or columns of your choice too. This doesn’t contain any formula or code. First, make a rough template like the following picture.Please download the file and observe Sheet2 before you go through the description below. We also stored some important named ranges in that sheet. We put some necessary information in Sheet2 of the workbook. Suppose your name is Shawn and you are a Full Time employee. If you want basic information from an employee, it can be very easy for him/her to put them in the fillable form of this section. Making an Excel Fillable Form for Employee Information 5 Examples to Make a Fillable Data Entry Form in Excel 1.
0 kommentar(er)
