title: Map unique values to a specific Excel sheet
body: <p>I'm wondering if its possible to create a <em>VBA</em> that map a random "numerical codes" from an excel Spreadsheet 2 (let's say <strong>column A</strong>) to a <strong>column B</strong>  (Spreadsheet 1).</p>
  
  <p>Some of the values on the spreadsheet 2 are repeated, <strong>I would like to build a unique correspondence (no repeated values from column A / Spreadsheet 2 to my column B / Spreadsheet 1)</strong>  </p>
  
  <p><em>Spreadsheet1</em>:</p>
  
  <p><a href="https://i.stack.imgur.com/ABFeY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ABFeY.png" alt="Spreadsheet1"></a></p>
  
  <p><em>Spreadsheet2</em></p>
  
  <p><a href="https://i.stack.imgur.com/5aPyj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5aPyj.png" alt="Spreadsheet2"></a></p>
  
  <p>Desired output, column filled from <em>Spreadsheet2</em> (<strong>Unique</strong>)values :</p>
  
  <p><a href="https://i.stack.imgur.com/QPAfQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QPAfQ.png" alt="Aim"></a></p>
  
  <p>Is this possible?? feasible??</p>