May 20 2021 05:41 AM
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 times i am unable to do it . I have attached the picture and excel file of same .
Regards
May 20 2021 08:15 AM
May 20 2021 08:24 AM
Solution@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
May 20 2021 02:04 PM
May 20 2021 02:28 PM
May 21 2021 09:36 AM
Here's a demo sheet I created a few months ago that shows how dependent drop downs can be created and used. Perhaps it will help. It's definitely possible.
May 20 2021 08:24 AM
Solution@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