We using dropdown dynamic list from master using OFFSET function for except blank data's,
Here, we would like to next two columns lists should allow/block based on the previous column list value, Kindly help us anyone, how to do this functions in excel?
Eg:
In above example,
First List, Should not be REMOTE LOCATION, then only the user allow to access next column lists, (OR) user should not allow to access other two columns, If Venue column list value is equal to "Remote Location" (Like red marked)
Attn: (All the Columns are Dropdown Lists - comes from Master Sheet = dynamic list using formula like =OFFSET(MASTER!$D$2,0,0,COUNTA(MASTER!$D:$D),1))
Here, we would like to next two columns lists should allow/block based on the previous column list value, Kindly help us anyone, how to do this functions in excel?
Eg:
In above example,
First List, Should not be REMOTE LOCATION, then only the user allow to access next column lists, (OR) user should not allow to access other two columns, If Venue column list value is equal to "Remote Location" (Like red marked)
Attn: (All the Columns are Dropdown Lists - comes from Master Sheet = dynamic list using formula like =OFFSET(MASTER!$D$2,0,0,COUNTA(MASTER!$D:$D),1))