Hi All,
I have a problem that I can't wrap my head around! and any help is MUCH appreciated...
I want to create a data validation list that will show a different list in response to the first column of each row.
and I want the lists to be generated according to another table.
it's hard to explain so I have uploaded my file.
there are two sheets, the first one is calendar where:
for example in cell C2 I want the drop down menu to show only (all users, web users, app users) and not show "content users" because for the value in B2 which is "email marketing" we are only allowed to select these options. this is indicated in the second sheet: "list1"
I don't know if I was able to explain what i want from this file.
and I hope you all can help.
thanks for your time
Bookmarks