Hello
I have a cell (E10) which has a drop down of 60 months. These months can change depending on the date entered in B4.
Let's say you select "Mar-15" .... being Month 3, because the value in B4 = 31/12/2014.
If the value in B4 changed to 30/06/2015, then the drop down doesn't refresh to equal the equivalent of Month 3, being "Sep-15".
Is it possible to do this?
Thanks
Bookmarks