Hi Jitendra.kumarverma, Find the Attachment. Hope it will help you. feel free to ask again if it is not clear.
Regard, Thamu On Wed, Jan 5, 2011 at 10:27 AM, Raj Mahapatra <rajafs...@gmail.com> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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
multiple validation.xls
Description: MS-Excel spreadsheet
