Hi guys i am in assistance of your brilliant brains, i have a working drop down menu which when selected i can select my data range such as below:
18/03/2009
19/03/2009
20/03/2009
21/03/2009
22/03/2009
23/03/2009
24/03/2009
25/03/2009
I am doing this by using a validation rule and having the source point to:
as a defined name.
Now this works perfectly, the first date on my list is the 18/03/2009, when i change the date to something like 24/04/2009 and change it again it show me the first one on the list (18/03/2009), what i would like is when i click the drop down menu to select a different date it will show me the current selected date on the menu, so in the above case i will be looking at 24/04/2009 on the drop down menu and not 18/03/2009.
Is this possible?
Thanks
Bookmarks