Correction from me. ignore the 1st part of my last reply to your guidance
Herbert, as I just saw the Product filter on the pivot table. However, is
there any where I cam see how you did this pivot, as its exactly the sort of
thing I wanted, but dont know how to get there. Thanks very much.

"Herbert Seidenberg" wrote:

Excel 2007 PivotTable
Consolidate Tables
With Chart and Macro
http://www.mediafire.com/file/jonz2mhtdzd/09_02_09.xlsm