Find Data in Pivot table

[swade730]

Hi,

I've attached a spreadsheet and I need assistance in writing a macro that would find/match the data inside a pivot table AND The data to be found is stored on another sheet.
More Importantly, I would like the format to match.

Thanks

[shg]

What does the pivot table buy you? You could get the same result by sorting the input table by player name.

[swade730]

Ultimately I will be summing the data in the pivot table on another sheet. Hence- The color coding for certain data values.

So When I create new pivots which may include New figures from the new data, I want to be able to reference what's been accounted for in previous pivots.

[swade730]

Any Solutions?