WHEN, Value Matches Z3=AC32:TJ32 , Then Dropdown menu on "AA3" with 'List' Source RangeName= the matched value "Z3=AC32:TJ32".
so if "dvd=dvd" which is a match , then Dropdown source RangeName= "dvd" on AA3
and if "cd=cd" a match , then Dropdown source RangeName= "cd" on AA3
this macro be...