VBA: sorting sets of data

Hi Excel forum,

I have a problem with sorting ‘sets’ of information in Excel 2003 and do not believe the standard sorting facility can accommodate my needs.

Basically I have employees who work multiple jobs for the same employer and I need to total their full time equivalent (FTE) across all jobs in chronological order and represent this information in either in a new column of dates and total FTE (preferred) or if it’s easier just sort the page out so I can manually total it after. The information extracted from our painfully limited HR program also has date entries where the FTE has not changed so dealing with these ‘duplicates’ in the same macro would be desirable but not essential.

I have a limited knowledge of VB but I do enjoy reverse engineering similar code and adapting it to my problem. I was considering attempting to adapt some code I have for finding and counting arrays but I wonder if there might be a more elegant solution that I’m missing. I have attached a basic example of what I am working with for reference.

Any help would be appreciated.