I work for a restaurant group that has recently started putting all employee's tips on paychecks. I made a basic spreadsheet to track all these tips because our Point of Sale cannot properly distribute tipout. My Excel knowledge is pretty basic, but some of the restaurant managers can barely enter data in the workbook without messing something up.
The challenge I'm facing is when we hire a new employee and need to add them to the workbook, or when we separate an employee and need to remove them from the workbook.
In the attached workbook, I have 3 spreadsheets that have employee data. "Week 1" is the first week of the pay period, "Week 2" is the second, and the "Payroll Total" sheet that is used to calculate their total paycheck. Week 1 and 2 are grouped by the position they work while the Payroll Total is simply alphabetical by last name.
Is there a way to enter a new employee on Week 1 and have that row automatically input into Week 2 as well as the proper row in Payroll Total?
Any help would be greatly appreciated. Thanks.
Bookmarks