Forum Discussion
Solved
Drop Down List Based on Previous Column's Drop Down List Selection - Categories/Sub-Categories
Any help is appreciated on the following. Thanks! I'm setting up a sheet with columns to categorize/sub-categorize data. I'd like a Category Column which has a Drop-Down List and a Sub-Category...
- Hello Donna,
The dynamic dependent drop-down list solution for you is similar to my reply here:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352333#M25764
Hello Donna,
The dynamic dependent drop-down list solution for you is similar to my reply here:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352333#M25764
The dynamic dependent drop-down list solution for you is similar to my reply here:
https://techcommunity.microsoft.com/t5/Excel/Data-validation-lists-flow-chart/m-p/352333#M25764
Dear Twifoo
I want to make same drop down lists with some Financial Data having Heads in Any Column and Sub Accounts in Next Column. I have seen your Maths Tracker workbook but it is not showing complete formula/range in source while applying data validation. Can you plz explain how can I relate Heads from one column to Sub Accounts in different columns.
- To see the details of the named formulas, paste the list of defined names by following the instructions in this link:
https://excelribbon.tips.net/T007731_Printing_a_List_of_Named_Ranges
- Thanks so much for the helpful direction, Twifoo!
- Welcome, Donna.
