Hello anyone.

I need help to solve this:

I have 2 different PivotTable and PivotChart in the same worksheet. PivotChart has 2 column A and B, PivotTable has 2 column E and F. In column A has the same value or number with column F; my question: is there any Function, formula or macro to join, index or match if column A match with F so column B will match with E, then I can join to make a chart from Column B and E.


Thank you very much in advance.