I have a report that relies very heavily on pivot tables. I have been asked by my manager to take another person's data and put it into the same model.

The data will fit in just fine, the issue is that his field names will be different than mine, therefore it will break every single pivot table.

I was wondering if there was a way to use VBA to use a 'find and replace' style function that will change the values area of the pivot table to use his data.

Example:

My data the name of the column is APDevice
His column name will be NADevice

I use the 'APDevice' column in many of my pivottables as a summed value field. Is there any trickery I can do here to go through each pivot and replace APDevice value fields with NADevice value fields?

If someone gave me a solution to this, I just might drive over and give you a bear hug!

:D

-Heather