? There are three worksheets in the Excel workbook: the employment form, the resignation form and the roster. The roster is full of information about employees on the job.
? The effect of human resources is:
When the new employee information is entered into the employment form, it will be automatically added to the roster.
Please click to enter a picture description.
Please click to enter a picture description.
When the employee's information is entered into the resignation form, the employee will be automatically deleted from the roster. ?
Please click to enter a picture description.
To automatically update the roster, the version before office365 will be very, very troublesome. In the office365 version, using Filter+Vlookup is very simple. (After setting the formula, set the table as a hidden value of 0)
= filter (employment! A2:D50, ISNA(VLOOKUP (employment! A2:A50, leave! A: A, 1,))
Please click to enter a picture description.
What if office365 is not installed? Then use the electricity inquiry function.
Operating steps:
1, loading data table.
Select employment form and resignation form respectively. Data- From table/area-? Close and upload to-? Create links only
Please click to enter a picture description.
2. Merge query
Select Table 7 and merge queries-? Select Table 7 and Table 8-? Select two table columns-? Invert to the left (only rows in the first table)
Please click to enter a picture description.
3. Save the merged result in a table.
Delete the last column? -? Format date-close and upload to?
Please click to enter a picture description.
Finally, the effect of PQ method is tested, and the result is OK!
The above is the introduction of how to make the employee roster form, and realize automation through excel function. Here, we also share a simpler method. Using the personnel roster, we only need to import the personnel information table of the enterprise, or directly enter the employee information on the platform, and we can realize automation. Can automatically generate various forms of employees, including resignation charts, birthday reminders and so on. In addition, you can also set the contract renewal reminder yourself to avoid forgetting to renew the contract and causing employment risks.