cascading dropdown and common list

Hello friends,   I am new to excel and VBA, kindly let me know how to filter second drop down based on value selected in first dropdown + how to get common values ?   please see example excel att...