Hi all
Can anyone help me figure this out please. I have 3 dropdown lists. List1 at cell F9 shows 2 options. Music and Videos. List2 2 then shows either movie types ie: action comedy etc. Or music type ie: rock jazz etc. List2 changes depending on selection in list1.
What i would like is list3 at cell J4 to change so that it either shows list of movies or list of music depending on what is selected in list1..At cell F9.
Please note that currently my movie list is filtered to only show all action movies or comedy movies based on list2 selection.
Any help appreciated.
Can anyone help me figure this out please. I have 3 dropdown lists. List1 at cell F9 shows 2 options. Music and Videos. List2 2 then shows either movie types ie: action comedy etc. Or music type ie: rock jazz etc. List2 changes depending on selection in list1.
What i would like is list3 at cell J4 to change so that it either shows list of movies or list of music depending on what is selected in list1..At cell F9.
Please note that currently my movie list is filtered to only show all action movies or comedy movies based on list2 selection.
Any help appreciated.
