Forum Discussion
Solved
Regarding Dependent drop down menu for a matrix in Excel
Hi Community , I need your immediate help . Can anyone please help me . I am trying to make dependent drop down menu for a matrix which has to placed in worksheet but even after trying so many tim...
Sabya007 The data validation list refers to ='[AL-rev3.xlsx]Master Data'!#REF!. Without the "AL-rev3.xlsx" file it cannot be determined what's wrong.
If you are trying to refer to the scenarios on the Master Sheet in the workbook you uploaded, note that you have quite a few empty rows in that range. But then it could look like this:
='Master Sheet'!$F$5:$F$21
Sabya007 The data validation list refers to ='[AL-rev3.xlsx]Master Data'!#REF!. Without the "AL-rev3.xlsx" file it cannot be determined what's wrong.
If you are trying to refer to the scenarios on the Master Sheet in the workbook you uploaded, note that you have quite a few empty rows in that range. But then it could look like this:
='Master Sheet'!$F$5:$F$21
Thank you,
I cannot post the sheet here due to company restrictions . Basically what i am trying is ,if someone selected "Custom_duties_for_incoming_goods " under Scenario he just have only one option "306000 - Freight costs" under "ledger account " and if he selected "Assembly " he have options under "Product Group ". Is that possible via Dependent drop down ?
Regards
I cannot post the sheet here due to company restrictions . Basically what i am trying is ,if someone selected "Custom_duties_for_incoming_goods " under Scenario he just have only one option "306000 - Freight costs" under "ledger account " and if he selected "Assembly " he have options under "Product Group ". Is that possible via Dependent drop down ?
Regards
