Dynamic Excel Drop-Down List in Excel that Updates Automatically!

[@asq8339]

This is so helpful, thanks

[@ExcelWithAnser]

Glad you found it helpful!

[@winardix]

hi. thanks. it's very inspiring idea...on excel

[@munthazirahmed3093]

This is interesting. I'm just thinking of ways to use this

[@ExcelWithAnser]

It sure is!

[@bsa18599]

Data validation expandable ranges are completely unnecessary if you're using Microsoft 365, which also features searchable crop down lists.

[@ExcelWithAnser]

Correct. I believe that's only in the web version. Thanks for sharing!

[@bsa18599]

No, not the only the web version all versions of MS 365, Home, Business and Pro. However if you're not using 365 then expandable data validation lists are the way to go.@@ExcelWithAnser