In my worksheet I have a dropdown list in cell A1 that has 6 model homes names. In A2 I have 20 selections for lots to build on. Each model of home can only fit on certain lots. How to I limit my choice of lots if I choose a particular model of home. example: Urban Modern home can only be built on lots 1, 3, 12. When I choose Urban Modern from the drop down list I only want Lots 1, 3, 12 to be available to choose from.
Thank you in advance for your help.
Bookmarks