title: VBA check value from column A exists in another workbook
body: <p>I am trying to build a macro that loops through a range of values within colA and check if they exist with another workbook. In one of them I would like to mark it "Worked"/"Not Worked"</p>
  
  <p><img src="https://i.stack.imgur.com/hku20.png." alt="Image">
  Any guidance on where to start?</p>