title: need to copy data from one sheet to another depending on a value of the first sheet
body: <p>i have never used excel except for in college and well that was a while ago, what i have is 3 sheets sheet 1 contains all user information sheet 2 is company information and sheet 3 is company member information, </p>
  
  <p>now what i need to do is this,</p>
  
  <p>i need to loop through sheet 1 column K and search for what is not "Individual" then i need the value of sheet 1 column A and put that in sheet 3 column C
  i also need the index of the same row that does not equal "Individual" and use that to grab the value of sheet 2 column A and put that in sheet 3 column B</p>
  
  <p>hopefully that makes sense and is actually possible and any ideas would be greatly appreciated!</p>