• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help in Data validation


I required help in data validation whether we can convert range to table so that it will update dynamically from the attached sheet.

RegionAsia Ocania
CountryIndiaDrop down menu in D4 should reflect only countries related to Asia Ocania
CityDrop down menu in D5 should reflect only City pertaining to D4


Thanks Peter and Pecoflyer for your time and support.

@ Peter can we use country validation and City validation as drop down in the sheet "Sheet1"