Feb 19 2019 08:45 AM
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 Column with a Drop-Down List based on the selected "Category" from the previous Drop-Down List.
Basically, if my lists look as follows below (Category List/Sub-Category List), how do I display the Sub-Category Drop-Down List for the corresponding Category (only) without having to include *all* Sub-Categories to choose from?
Categories Drop-Down List:
Feb 19 2019 11:51 AM
SolutionFeb 22 2019 12:07 AM
Hello Donna,
Except that there are only 2 drop-down lists herein, the attached file is exactly the same as that which I uploaded in this link, which has 3:
Cheers,
Twifoo
Mar 30 2019 06:51 AM
Mar 30 2019 07:00 AM
Oct 05 2019 04:58 AM
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.
Oct 05 2019 08:14 AM
Feb 19 2019 11:51 AM
Solution