Hi all, I have an excel sheet with the details of my contacts from all across the country. The sheet has two columns - District and State. The state column is a dropdown list and I want to make the District column also a dropdown list. My requirement is that when I select one state, the list of districts falling in that state only should appear in the dropdown in "District" column.
Suppose, my states are listed in Az65117 to AZ6550 and in next column all the districts of India. My state column with the dropdown list is Q and district column is O. Can you give me the formula with description to achieve this in Excel? Thanks, Satguru ___,__.___ "Life's battle do not always go, to the stronger or faster man. But sooner or later the one who wins, is the one who thinks he can." Satguru Rathi. Mobile: +91-9971231627 Email: [email protected] [email protected] Skype: satgururathi Facebook: http://www.facebook.com/profile.php?id=100002489756116 Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
