Forum Discussion
Solved
Issues on dynamic ranges for drowpdown lists in excel
Hi all i am having issues creating a dymic range for my drop down list in excel basically, i have started literally reworking the example provided on https://support.microsoft.com/en-us/office/c...
You don't need sheet name in reference, just
If you add more values into the table data validation picks the up if the table and the cell(s) with data validation are in the same sheet.
Alternatively in Name Manager you may define the name (e.g. DVList) as =Table1[City] and use =DVList in data validation.
Dear Sergei
What you are suggesting is exactly what i want to do, but then, when i do it, it ends with the error message in the screen capture in my previous message.
what i want is that error message to end,
Regards
WunterSlaus
What you are suggesting is exactly what i want to do, but then, when i do it, it ends with the error message in the screen capture in my previous message.
what i want is that error message to end,
Regards
WunterSlaus
It's hard to say what's wrong without the file. Please check attached one if it works in your environment.
your attached file was very helpful, i have it working now
Thank you very much
Regards
Corstiaan
WunterSlaus , you are welcome