title: Copy a single cell and paste to a location determined by adjacent cell value
body: <p>I have a value in cell H17 on worksheet 1.  It is next to a dropdown list of values in cell G17.  I would like to copy and paste H17 into the adjacent location in column C where G17 matches a value in column B.  This is all done on the same worksheet.</p>
  
  <p>I have't tried any VBA methods yet but have spent far too long trying to find the solution.</p>
  
  <p><img src="https://i.stack.imgur.com/nY6Oe.png" alt="Spreadsheet example"></p>