I have an Excel workbook designed to keep track of employees vacation and sick time. It contains a master listing of employee names and their hire date on one sheet. Then each additional sheet is a pay period. On all sheets all the names are linked from the first sheet On the first actual sheet, I put a beginning balance of time (in hours) that they have available to take off in one column, then we fill in the time they've taken off for that pay period (which is about two weeks) in several different columns, then a formula to do the math to figure the remaining time in the last column. On the next sheet it's all the same except the beginning balance is linked to the previous sheet's ending balance. The problem is that when we sort by the employee's names to put them in alphabetical order, the linked cells don't move with it on all of the worksheets. Is there something I can do to fix this or should we just not do any sorting??
Don’t have an account yet? Register yourself now and be a part of our community!