Display List Of Open Items

Hello everyone,

I want to create a workbook that will track "Open" items that are past the due date from project events. I attached a sample workbook to better explain my intentions. There are 4 worksheets. 3 of the worksheets are for different events and 1 worksheet (Summary) to display all open items (Event Name, Task, Status, Date, Responsible Person, and Manager) from all three events. Not all the open items need to be listed, only the ones that are currently past due.

I'm hoping to have an easy way to do this. I'm not sure if I have to use a macro or not. If so, one important factor is that I will be adding new Event worksheets every week and I will need the macro to search them as well.

I hope my explanation made sense. Please take a look at my sample for clarification.

Thank you in advance to anyone willing to take a look at this for me.

- Justin

Hi Justin,

There is an old tool called the Pivot Table Wizard that "consolidates" regions into a single pivot table. See the attached where I've tried to see if it would solve your problem.

See how to add this wizard to your QAT at:
http://www.pivot-table.com/2010/07/1...in-excel-2007/

Hope this helps.

@ Marvin is there any way to change the data source like standard pivot table ?

Using the Consolidation Wizard you add the sources of the data.
See an example of what I mean at
http://blog.executivetrainingsolutio...ltiple-ranges/

Originally Posted by MarvinP

Hi Justin,

There is an old tool called the Pivot Table Wizard that "consolidates" regions into a single pivot table. See the attached where I've tried to see if it would solve your problem.

See how to add this wizard to your QAT at:
http://www.pivot-table.com/2010/07/1...in-excel-2007/

Hope this helps.

Hi Marvin,

How do I change the Number Format. For example I want the Date to be a Date and Names to be Text. It seems to be as if you can only set one type of format.