title: Automatically extract data conditionally from another worksheet .Are there any options for me to automate this process using Excel Macro or Formulas?
body: <p>I have an obstacle to automatically retrieve the data that are unique from the New Info that are the not available inside the Masterlist and add into the Masterlist on a routine basis.</p>
  <p>Are there any ways to setup formulas or macros to identify the list in the Masterlist that are not available in the New Info worksheet?</p>
  <p><a href="https://i.stack.imgur.com/eSiwJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eSiwJ.png" alt="Master List" /></a></p>
  <p><a href="https://i.stack.imgur.com/52Ge7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/52Ge7.png" alt="New Info" /></a></p>
  <p><a href="https://i.stack.imgur.com/Hlp4T.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Hlp4T.png" alt="Ideal Result" /></a>
  <strong>Above would be the Ideal Result</strong></p>