Hi Greg
[snip]
Now the problem is that I can get the formulas to work on the first
worksheet and give me the information that I need. But when I
reference the four digit employee number onto a page that I then sort
to remove all the blank rows, the employee number then becomes 2 from
0002 (if under 999) which isn't too bad because I can format the
columns to 0000 but it sorts with a ton of blank rows in between.
The sheet is then copied onto a new form that I send to payroll so I
cannot leave the blank rows. (The blank rows are payroll items that
aren't relevant to that employee's current payroll information) The
sorting and copying is all done with a macro if that helps.

One question: How do you reference the employee data (with a simple
cell reference or something else)
Next question: If you only want to remove blank rows, probably
filtering (not sorting) would be the way to do this (goto ' Data -
Filter', choose 'Autofilter' and in the appearing drop down choose 'Non
blanks')

Frank