Hi,

I need help in building macro/s to perform the following:

I use a typical work book with some 10 odd worksheets containing details of different tasks / action items pertaining to multiple projects with time deadlines etc., for tracking. this is the workbook I share with the Managers of different groups who will directly populate / update the status of different items in the worksheet specific to their operations.

A typical task / issue listed herein will have different "Priority" -(High, Medium, Low), "Status" - (Open, Closed) and also Date of 'Closure' of the item.

Now what I need to do is to be able to filter out the items that meet different conditions formed by combination of Priority, status and Date and be able to update incrementally into different sheet/s.

Can any one help me with this macro build.. Can it all be contained within one macro or do we need different macros for different combination/s.

I will be thankful for help in this regard..

Cheers
Venkat