title: Macro code to read value of a cell in Excel & enter a given value in a second sheet on corresponding row
body: <p>Looking for some help with a fairly basic excel macro to read a value in a cell on one Excel sheet and then find that value in a second sheet and enter a pre-defined value into a specified cell in that row.</p>
  
  <p>To break it down...</p>
  
  <ol>
  <li>Read the value of a given cell in sheet_1 (this will be an ID number)</li>
  <li>Go to sheet_2, find the ID number in column_a</li>
  <li>Go to a given column in that row</li>
  <li>Write a pre-defined value into the cell</li>
  </ol>
  
  <p>Thanks!</p>