Auto filter using selected criteria from a listbox

Hi

I am wanting to record a macro that will auto filter a data set based on multiple criteria selected from a listbox.

As an example the listbox would have the years 2010, 2011, 2012 and 2013.

By selecting the years 2010 and 2011 for example, I want to auto filter the year column in the data set (column A) so that it shows only 2010 and 2011.

Thanks for the response but still no luck.

I want to be able to choose from multiple criteria for the auto filter option.

I have a data sheet with a large number of rows but column A is the year (either 2010,2011,2012 or 2013). I wanted to know if it was possible to have a list box that had a list of the years and when selected the data sheet would auto filter for those years selected. For example if only 2010 is selected only the 2010 rows in column A show or if both 2010 and 2013 are selected both the 2010 and 2013 rows in column A show.

If this can be done better without using a list box for making the selections then please let me know.

Thanks again.

Thanks again!

It doesn't seem to filter if only 1 year is selected. Is it also possible to make it so that more than 2 years are selected (anywhere from 1 year to all of the years in the list box)? Book1.xlsm