I have a list of tasks for a team which includes start dates, names and a
couple of other criteria.

Is it possible to create a sepatate workbook which looks at the first one
and selects the rows which correspond to a particular name or start date etc?

Also if it can be done, can it be linked so that it automatically updates if
someone changes information in one document?

If it can be done, could you tell me how?

Cheers

N