Comparing Pivot table entries with cells in another worksheet
I need to compare the entries in a pivot table with another worksheet. When
an entry is found i wish to highlight the cell and then move to the next
entry in the pivot table and repeat until the top 10% of the pivot table has
been checked.
I have been able to programme to ID the 10% but cannot write the correct
coding for checking betwee different worksheets.
TY in advance.
|