Display List Of Open Items

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.