I created a payroll workbook that calculates the hours daily for each employee. The problem is that when it's time to make another workbook for the next payperiod I would like the terminated employee not to show and leave the current one. These pages are linked to other sheets, but not to other workbooks.
Sample:
Employee name Dept ID rate Status
John Doe 0002 0008 7.50
Jane Doe 0002 0001 8.50
Jimmy Doe 0002 1254 9.00 Term
So when the user saves and copies workbook only the current employees with their link data would remain in the new workbook
Sample:
Employee name Dept ID rate Status
John Doe 0002 0008 7.50
Jane Doe 0002 0001 8.50
Jimmy Doe 0002 1254 9.00 Term
So when the user saves and copies workbook only the current employees with their link data would remain in the new workbook