I created a drop-down list through data validation of the 50 states.
I want to select a state from that drop-down and populate an entire separate column full of that states counties. I have a table on a separate worksheet that has columns "State" and "County" as A and B respectively. column A has the state name the entire length of the counties in column B.
I have searched for about 2 hours through the internet and cannot seem to pinpoint one best way. Any help would be great