title: Excel - copy certain rows from worksheet in another worksheet
body: <p>I have found ways to solve this issue but I don't know how to tailor them to my specific problem. I've never written a marco or any VBA script before, so please be specific with your answers. </p>
  
  <p>I have an Excel workbook with one worksheet named "foods", and four other worksheets named "snack choices", "breakfast choices", "lunch choices", and "dinner choices"</p>
  
  <p>The heading in the "foods" worksheet looks like this:</p>
  
  <p><strong>Food Amount Calories ... ETC ... Type</strong></p>
  
  <p>Where "Type" contains "breakfast" "snack" "lunch" "dinner" or a combination of 2+ choices. </p>
  
  <p>I'd like the entire row to copy to the corresponding "snack choices", "breakfast choices", "lunch choices", and "dinner choices" worksheet according to the value of the "Type" field in the "foods" worksheet. </p>
  
  <p>For example, if I enter a new row into the "foods" worksheet with the "Type" field as "snack / breakfast" I'd like for the row to automatically appear in the "breakfast choices" and "snack choices" worksheets. (I could remove the slash or replace it with another character if that makes it easier)</p>
  
  <p>Thank you in advance!</p>