title: Excel VBA script to populate another sheet conditionally
body: <p>I would like to write a VBA macro for excel through which i want data from a master sheet to populated to another sheets conditionally.</p>
  
  <p>for example, my master sheet ("Sheet1) has multiple rows and column. The condition for data population from Sheet1 to Sheet2 should be based on these condition</p>
  
  <p>(1) Only rows which has a particular string in a column (say "keyword" string in column D)</p>
  
  <p>(2) Only few columns to be copied from Sheet1 to Sheet2 (say column A,B,E &amp; G)</p>