Link two ComboBoxes
I have a list of cities in column A1 and a list of zip codes in column B1. List 1 is tied to ComboBox 1, and list 2 to ComboBox2. How can I make sure that when I select, for example, the City Baltimore from Combobox1, I only get a list of all zip codes for Baltimore available to select from in ComboBox2?
I tried data validation which does not seem to work.
Help! please. This is a Biggie Big!