I need to create cascading dropdowns, but there is a limitation to the excel function where the name must start with an underscore or letter. Here is an example of what I'm trying to do:
Product 01P230578 02P528931 03P209859 01P230578 20 1 50 02P528931 30 5 100 03P209859 50 10 200
When I choose the Product, it will only produce a list of numbers from that product.
I followed the instructions https://www.ablebits.com/office-addi...n-lists-excel/ , and was able to create dependent dropdowns with lettered names. But I cannot create them with names like "03P209859." Is there a way to create dependent dropdowns with numbers as the Names?
Bookmarks