title: How to create multiple Excel worksheets based on filtering of a certain column?
body: <p>I have the following data:</p>
  
  <pre><code>Name    Year    Sales
  Ratata  2012    10000
  Pikachu 2013    20000
  Akens   2014    30000
  Zubat   2012    40000
  Onyx    2014    30000
  Snorlax 2014    20000
  </code></pre>
  
  <p>I would like a new worksheet for each of the years in the table. In this example, I will expect 3 new worksheets - 2012, 2013, 2014. Each will contain only the rows with the relevant year. In other words, I'd like to filter the table above so that for each year a new worksheet will be created. </p>
  
  <p>I know how to create multiple worksheets using Pivot Table tools (Analyze - options - show report filter pages). I am not interested in a Pivot solution, but to keep my original table structure.</p>
  
  <p>I read about the advanced filtering method but it won't help if I want to create 100 new worksheets, for example.</p>
  
  <p>Is there any automated way? Preferably without VBA.</p>