Task Tracker

[msal727]

Hello!!
Does anyone know how to make a sort of interactive task tracker? I have a tracker that has different tabs, one for each client. Each tab has deliverables for that client and the due date. I want the "Summary tab" (main tab) to show the items that are pending, in-progress, to-do, etc but with the corresponding due dates. Ideally I would like the due dates to show in order of priority (what's due next) and alert the user if something is past due. If a VBA code is required thats ok. Any advice or guidance would be highly appreciated! TIA!

 

[pbornemeier]

If the format of each client's worksheet is standard and task status codes are also standard then VBA code could be developed to extract tasks that met any desired criteria.
I would suggest using a drop down box (Data | Data Validation), that references a named range for the list (=NamedRange)) to ensure that the codes are standard and other validation to ensure that dates are "real" dates not "mid-January" or another non-standard value.