title: Copy if part of the text cell found excel VBA
body: <p>I am having a hard time to write that VBA...</p>
  
  <p>Attached picture should help to understand what I need to do</p>
  
  <p>Problem:</p>
  
  <p>a) If text "FAA" is found in Sheet1 Column B then copy cell C in the same row to Sheet2 Column A.</p>
  
  <p><a href="https://i.stack.imgur.com/atvEw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/atvEw.jpg" alt="enter image description here"></a></p>
  
  <p>then,</p>
  
  <p>b) Delete those cells in row B and C of Sheet1.</p>