My functions are not in sheet 1 as it would come up as Ref's so it is hard data. I tried the vba code...works kind of...i have multiple employees in the same sheet. The vba provided smashes them all as one employee.. Great start and works how i want it to..just need it to separate out the employees too.

Thanks for helping...it currently takes FOREVER to sort now.