title: Copy rows with a specific value to another sheet
body: <p>I have a huge Excel worksheet which contains 200,000 rows. The data is about 120 subjects which are listed in column B, like <code>sinani-01</code> to <code>sinani-120</code>. I need to copy all rows where column B contains <code>sinani-01</code>, for example, and paste them to new sheet. Or at least just select them?
  Can you please let me know how to do this in VBA?</p>