Data Validation List to automatically update

**PDBartlett** · 10-23-2014, 07:07 AM

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

**Winon** · 10-23-2014, 08:48 AM

Hello PDBartlett,

I don't think it would be possible to provide you with a ready answer without seeing how you have your Sheet and formulae setup.

Regards.

**PDBartlett** · 10-23-2014, 09:02 AM

Hi Winon

I have attached an example.

Data Val List.xlsx

**Winon** · 10-23-2014, 10:16 AM

Thank you for the feedback PDBartlett,

Unfortunately, that is how a Dropdown Box works, it is not Dynamic. We could however "Automate" it slightly for you to select a New Month when you change the Year End.

Hope that helps.