title: Search and fill the cell
body: <p>I require the searching functionality in Excel Macro.</p>
  
  <p>Scenario:</p>
  
  <p>Step 1) Excel1.xlsx have one column as primary key which I have to find in the Excel2.xlsx</p>
  
  <p>Step 2) If the matching is found in the above step, then have to take a value of another column in Excel2.xlsx (from the same row which match the step 1) and fill in the Excel1.xlsx. </p>
  
  <p>Is there any VBA macro to solve this issue?</p>