http://www.excelforum.com/excel-prog...ipulation.html

Your reply was just what I need but I am new to VBA and cannot understand it yet.

I will have one sheet with controls that I want to alter all of the same fields for each pivot table in the workbook.

For example is from a validation list in cell a2 on worksheet summary I select 123456 I want it to change all pivots with the field SKU to 123456.

Thanks in advance for the help.

MolDog