How to create multiple Excel worksheets based on filtering of a certain column?
<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>