VBA - 2010 - How to invert a filter
<p>I am wondering about a simple solution for reversing the filtered values. Although it seems to me to be an easy task, I have not had a success while researching on the internet. </p>

<p><strong>The situation and problem</strong>: I have a table with multiple columns, and lot of rows (exact amount does not matter obviously) and I want to see what was <em>not</em> filtered in exactly one column. The problem is that I normally need to do a lot of clicking</p>

<p><strong>For example</strong> - in the database of projects I have filtered the ones worth over <code>500 000 €</code>, which are mine and are coming from a specific country. By one click I would like to see which ones are below <code>500 000 €</code>) but are still mine and coming from a specific country.</p>

<p>Possible solutions which came to my mind:</p>

<ul>
<li>Create a unique list of what is filtered, unfiltered, and create an unique list of full column, AdvanceFilter by the difference. <em>(That's my white horse - it might work in my opinion)</em></li>
<li>Go through each filtering options and check/uncheck one by one.</li>
<li>Screenshot filters, transfer to text, create a unique values at the column, invert the filter in advanced filtering <em>(very crazy idea, came out of desperation)</em></li>
<li>Somewhere easily take a list of what's filtered and inverted it by easy function <em>(that was my initial thought but not working!)</em></li>
</ul>

<p><strong><em>Does anybody has an idea how to approach this situation?</em></strong> 
<em>I am able to try the VBA on my own so I would be happy if you can point me in the right direction. Of course I would welcome your thoughts in code too.</em></p>