example: Column A I want to list say McDonalds, Dairy Queen, Burger King, White Castle. And then I want column B to be validated to just a range of cells depending on the criteria entered in Column A. Say you chose McDonalds. So in Column B I only want McDonald’s menu items to come up.
does that make sense? Thanks for any help