title: VBA - Pulling a value on the same row based on another column
body: <p>I need a macro that will scroll down column B until it's values pass 6. Then, on the first value that passes take the value on that row from column A (I'll refer to this value as X) Then go to another sheet in the same book and insert 3 rows after column C has become greater than or equal to X. I am very new to vba and have no idea what I'm doing but, I'm in a time crunch and could use some help. I don't know if this will help but I wrote out some super pseudo code that might be able to explain it. (not only do I need an X but I also need a Y to insert 3 rows in another spot on the second sheet)</p>
  
  <pre><code>Survey.cell
      dls = Where(column("J") &gt; 6.0 get.row)
      kop = Where(column("B") meets dls)
  
  Survey.cell
      inc = Where(column("C") &gt;85 get.row)
      lnd = Where(column("B") meets inc)
  
  Journal.cell
      Where cloumn("M") &gt;= kip insert.row &amp; inerst.row &amp; insert.row
      Where column("M") &gt;= lnd insert.row &amp; insert.row &amp; insert.row
  </code></pre>
  
  <p>The closest thing I could find to this is here:
  <a href="https://stackoverflow.com/questions/15910913/how-to-find-text-in-a-column-and-saving-the-row-number-where-it-is-first-found">How to find text in a column and saving the row number where it is first found - Excel VBA</a>
  but, it's not exactly what I need. I appreciate any help offered. Have a good day!</p>