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
It's not clear what the drop downs should be.
May I ask a question: this looks like it could be a school assignment of some kind, is it?
If it is, we'd be doing your homework for you. I have an example I've built of dependent drop downs...in fact if you search this website you could probably find some--which would be just fine. You'd still have to adapt the method to your own...
If it's not the case, then let us know and I'll post my example sheet.
May I ask a question: this looks like it could be a school assignment of some kind, is it?
If it is, we'd be doing your homework for you. I have an example I've built of dependent drop downs...in fact if you search this website you could probably find some--which would be just fine. You'd still have to adapt the method to your own...
If it's not the case, then let us know and I'll post my example sheet.
Dear Sir ,
I am employee to a company . I am having hard time solving this . This is cut and paste from report sheet , which I can't post here . I was doing this to reduce the error , which occurs due to wrong entry by suppliers.
Thank you.
I am employee to a company . I am having hard time solving this . This is cut and paste from report sheet , which I can't post here . I was doing this to reduce the error , which occurs due to wrong entry by suppliers.
Thank you.