title: Excel VBA loop through Pivot Items
body: <p>I want to loop through my pivot items and check if they exist in another table, see my Example Screenshot:</p>
  
  <p><img src="https://i.stack.imgur.com/d6If5.png" alt="Example Pivot Table"></p>
  
  <p>So i want to loop through all the colors, checking if they exist in another table (e.g. in another sheet or so):</p>
  
  <p><img src="https://i.stack.imgur.com/l2wBf.png" alt="enter image description here"></p>
  
  <p>Is there any way to do this so there would appear a Message Box that the color purple was not found in the list?</p>
  
  <p>Many thanks for your help!</p>