Synchronize 2 Pivot Tables with a Combo Box

So I am using this (http://datapigtechnologies.com/flashfiles/pivot10.html) tutorial to synchronize a few pivot tables in one of my workbooks. But it doesn't work correctly because not all my tables have the same values. For example: The matching column name is RepName, and I have multiple tables with RepName as a column, but not all reps are in all tables. I'd like it to select (all) if one of the pivottables does not have a rep. Any help? Excel 2003, but if you guys have a better 2007 code, then I can use 2007.

Please Login or Register  to view this content.

Bump for answer.

Bump.

Bumpy Bump.

And another bump.

will i ever get some kind of response?

bump. for bump

this is a bump

bumping once again.

Go here for answer.