title: Macro for Excel: If Column B has "X", then copy entire row and paste in Worksheet named "Column B"
body: <p>I have limited experienced of writing macros, and I'm looking to update a current spreadsheet used at work.  Currently we copy the entire Master worksheet and paste it into other worksheets before sorting for the "X" in certain columns to delete other rows on the master worksheet.</p>
  
  <p>What I am looking to do is search the Master Sheet, and if Column B has an "X" then copy the entire row and paste it into a worksheet named "Column B".  Then, once Column B was completed and pasted, it would look at Column D. If Column D had an "X", it would copy the entire row and paste it in worksheet tab named "Column D".</p>
  
  <p>Thanks in advance!</p>