Hello all,
I posted a similar request before but think I over complicated it and scared people off
I'm trying to populate a drop down list with months (Cell A3 in 'Report' sheet) from a list of dates that is to be updated regularly, and not a predefined list.
The dates are to be displayed in the format of 'Jun-14' and taken from information in the 'Programmed Date' column on the 'Tracker' sheet.
Future dates will be added to the 'Programmed Date' column on a regular basis. Many will be in the same month and year, some will include months not already included and I would like the drop down box to reflect the newly added months as options.
Many dates will also be from the same month e.g. 20/05/2014 & 30/05/2014 however I do not want duplicates of the same month, in this case 'May-14'.
Hope someone will be able to provide a solution
Thanks
Bookmarks