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??
how is it linked ?
do you look for "Smith"'s cell and link it to Smith's corrosponding cell on the other sheet ?
Have a look at the =VLOOKUP function.... this will search down a column for the name "Smith" and return his values accordingly, no matter where he is before or after any sorting
As luck would have it, I have a VLOOKUP example spreadhseet, written in plain English if you'd like it..... emial me at [email protected] and I'll send it through
Have you tried using a pivot table to query the information? i.e. combine the the relevant items into one table and using a pivot table to get the information out.