hi Jitendra, First, Define the name range of the countries as "Country" Second, Define the name range of states as Country Name e.g. For all indian states give name range "India" Third, In first column use data validation of country in Second column use this formulat in Data Validation in List as "=INDIRECT(SELECT THE CELL OF PREVIOUS COLUMN WHERE YOU HAVE USED COUNTRY")
If you have further problem, kindly view the attachment. On Tue, Jan 4, 2011 at 8:45 PM, Jitendra Verma < jitendra.kumarve...@gmail.com> wrote: > Hi All, > > I have a question related to data validation in excel. > Below is the description.. > > I want to create two dropdown list using the data validation list. one is > for countries and other is for State of the countries. > > My question is if i select country from first dropdown thee second dropdown > populate only the state of India country. > > -- > *Thanks and Regards,* > Jitendra Kr. Verma| Sr. Software Engineer > Mob: +91.9700695633 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
data validation example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
