ggraves1968
New Member
- Joined
- Oct 2, 2008
- Messages
- 43
My training manager has a workbook that she wants to automate.
It has a master works schedule with employee names in one tab, and a training tab. The training tab has a list of employees in column A that pulls from a master work schedule. In columns B through G she has headings that represent training they must complete. Currently it is a manual process to place the "x" and delete the "x" when an employee change is made and as training is completed.
Does anyone have a suggestion as to a way that if an employee changes on the master schedule that it will update the name in the training tab and clear out the "x"?
It has a master works schedule with employee names in one tab, and a training tab. The training tab has a list of employees in column A that pulls from a master work schedule. In columns B through G she has headings that represent training they must complete. Currently it is a manual process to place the "x" and delete the "x" when an employee change is made and as training is completed.
Does anyone have a suggestion as to a way that if an employee changes on the master schedule that it will update the name in the training tab and clear out the "x"?