title: VBA Matching across different sheets
body: <p>New to VBA. I have three sheets: Sheet 1 and Sheet 2 track information for two different parts. Both sheets have a column named: "Set Number" where values range from 1-8. I'm trying to then extract ID Numbers (Cell(a9)downwards) of the parts with matching Set Numbers to Sheet 3. </p>
  
  <p>On Sheet 3 Column 1 would pull from Sheet 1 and Column 2 would pull from Sheet 2 for Set 1; Columns 3 and for would do the same for Set 2, etc.</p>
  
  <p>Appreciate any help.</p>