So here is what I am trying to do. I have a drop down list that has a bunch of names. The names are Q3_2011, Q4_2011, Q1_2012, Q2_2012, Q3_2012, Q4_2012, Q1_2013, Q2_2013, Q3_2013, Q4_2013, Q1_2014, Q2_2014, Q3_2014, Q4_2014, Q1_2015, Q2_2015, Q3_2015, Q4_2015.
I created two named ranges for...