Forum Discussion

DonnaE's avatar
DonnaE
Copper Contributor
Feb 19, 2019
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...
excel
Formulas and Functions
Kanwar_Bilal's avatar
Kanwar_Bilal
Copper Contributor
Oct 05, 2019

Twifoo 

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.

Resources