Hello,

I was hoping someone could help me with an issue I am having regarding drop down lists. I am using formulas which are quite complex (to me!) to establish named ranges, using functions list INDEX, OFFSET and MATCH.

I am creating a dashboard with a dropdown list of months which feed into graphs etc.. I source these months from a pivot table, however this defaults as alphabetical order, when I need it to be chronological. When I drag the fields so it reads Jan, Feb, Mar etc this updates in the drop down box however it picks the wrong figures out of the pivot table.

Is there an easy way to fix this? Or would I have to show all my formulas to look where it has gone amiss?

Thanks in advance.