Merging information based on criteria

Hi
Here is an issue I come across now and again: Say that we have a list of data, e.g. a time planner for a department. Each employee is listed with various assignments/tasks with start dates and end dates. The start date for any assignment is the date after the end date of the previous assignment. One data row for each assignment or task.

What I want to do, is to chain the assignments together in one new line somewhere else in the same spread sheet., i.e. to generate a new overview with only one line per employee where start date is the start date of the first assignment, and the end date is the end date of the last assignment.

Can't get this to work properly...if anyone has a relevant VBA code I would be much obliged. Example spreadsheet enclosed...


Best regards,

Knut Kvinnsland

That easy...perfect, many thanks. Hope to return the favour some day!

Regards,
Knut