Good Morning,
I have the following question:
Taking a table with some data on a sheet and a dynamic table on another sheet, I need a macro that:
Read each row in the table (first 3 values) and if these three data coincide with one of the rows of the pivot table, read a pivot table data and put it in the other table. If there are not any row that match, the cell is filled with a "No match"
When finished, there must be a report of the number of cells filled properly and the number of cells filled with "no match" message.
In short, I need to search within a PivotTable.
It would be very helpfull for me
Thank you


Example:
PivotTable1 (Sheet1)
TAG Color Origin Rate Average of Price EUR
1654 Blue UK 1200 2567
6872 Blue Canada 250 564
6471 Red Italy 150 236
8853 Green Canada 1500 3520
2146 Blue UK 800 1483

Table1 (Sheet2)
TAG Color Origin Rate Price EUR
XXXX Blue UK 1200 2567
XXXX Red Canada 250 No match
XXXX Red Italy 150 236
XXXX Green Canada 1500 3520
XXXX Blue UK 250 No match
XXXX Blue UK 1200 2567
XXXX Blue UK 850 No match
XXXX Red Italy 150 236
XXXX Blue Canada 250 564
XXXX Red Italy 150 236
XXXX Green Spain 1500 No match
XXXX Blue Canada 250 564
XXXX Blue UK 300 No match
XXXX Green Canada 1500 3520

Message: There were 9 matches and 5 no matches