Create new drop down from previous drop down selection
I have a worksheet where the 1st column is the Region and the 2nd column is
the sub-banner(areas within the region). I have created a drop down on the
first column where you can select the region. Is there a way to create a
drop down in the 2nd column where it only shows the sub-banners associated
with the region that was selected in column 1 if I have the sub-banners
separated by Region on another worksheet?
|