on my sheet I am trying to make a drop down list for a date range. Now I would want my source data from sheet 'Weeks' and it would be filtered like so:
1st: in C5 a year would be selected in the weeks sheet, Weeks!B6:B41 is where the years are located (12 lines of each year - 2012,2013,2014)...