title: Match and retrieve values from another workbook
body: <p>I'm very new to VBA so not sure where to start with this one. I have two separate workbooks saved in the same file location (Workbook 1 and Workbook 2)</p>
  
  <p>what i'm looking for is When column C is populated in workbook 1, I want a macro that searches for that number in workbook 2 (column A).</p>
  
  <p>If a match is found then I want the corresponding values from column C, D, E and G in Workbook 2 to be copied onto workbook 1.
  <a href="https://i.stack.imgur.com/UzMoD.png" rel="nofollow noreferrer">Here is the values populated in Workbook1, then matched in Workbook2</a><a href="https://i.stack.imgur.com/mmE0B.png" rel="nofollow noreferrer">Here is the expected results, with the matched values populating Workbook1</a></p>
  
  <p>Workbook 2 won't be opened by the user, they will just click a button in Workbook1 and it will populate the data.</p>
  
  <p>I currently have this working but with Vlookups which has greatly slowed down opening workbook 1.</p>
  
  <p>any help is appreciated.</p>