andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
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)
2nd: in D5 a period(month) would be selected (1-12) Weeks!C6:C41 is where the periods are located.(3 lines of each period)
3rd: in E5 a week would be selected (1-5) that data is in Weeks!F2:AN2. There would be seven of each (1st 7 columns are week 1, 2nd 7 are week 2,etc...)
Now what is left will be seven cells with dates in them and that is what I would like to have in the drop down box.
The range for the dates that are being sorted through is: F6:AN41
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)
2nd: in D5 a period(month) would be selected (1-12) Weeks!C6:C41 is where the periods are located.(3 lines of each period)
3rd: in E5 a week would be selected (1-5) that data is in Weeks!F2:AN2. There would be seven of each (1st 7 columns are week 1, 2nd 7 are week 2,etc...)
Now what is left will be seven cells with dates in them and that is what I would like to have in the drop down box.
The range for the dates that are being sorted through is: F6:AN41
