Project management in excel - master task list system

[Princi87]

Hi guys,

I am trying to put together a project management tool in Excel.
It is Basically several Sheets, one per each project, in which I have a series of tasks and their due dates and status.
I can highlight them and put them in high priority with the today function in each individual sheet. I would like though to have another sheet that acts as a master task list by picking up from each project the more urgent tasks, say 5 days from = Today.

The goal is to have a general recap of all tasks that are due in 5 or less days, or overdue on a single page and not divided by each project.

Would also be cool to have them disappear once status is set to Done but that is optional.

Let me know if I explained myself clearly enough.

Thank you in advance for your kindness and support.

Leonard

[BlindAlley]

You should really post a mock up worksheet and highlight what needs to happen by showing your expected results. That way anybody willing to assist has a worksheet to test their formulas and ideas.

[Princi87]

Hi Blind Alley,

here is the attachment.

Sheet one is the desired result with no spaces and a unique list that picks from all projects tasks.

Can you see it?

[JeteMc]

An easy way to accomplish this would be to use your current master task lists as helpers then consolidate using*:

Please Login or Register  to view this content.

*Denotes an array entered formula which is confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Note: I suggest that you not use merge and center on either sheet as it complicates the use of formulas.
Let us know if you have any questions.

[Princi87]

Hi Jete,

thanks for your great solution. I am trying to get familiar with the equation now. Thanks again!

Leo

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.