View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Iain M Iain M is offline
external usenet poster
 
Posts: 2
Default 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.