On Jul 21, 6:54*am, chandra sekaran <duraichan...@gmail.com> wrote:
> Region *State * Capital Languages
> _____________________________________________
> Central India * Bihar * Patna * Hindi
> Central India * Chandigarh * * *Chandigarh * * *Hindi
> Central India * Chattisgarh * * Raipur *Hindi
> Central India * Jharkhand * * * Ranchi *Hindi
> Central India * Madhya Pradesh *Bhopal *Hindi
> Central India * Rajasthan * * * Jaipur *Rajasthani
> Central India * Uttarakhand * * Dehradun * * * *Hindi
> East India * * *Assam * Dispur *Assamese
> East India * * *Haryana Chandigarh * * *Hindi
> East India * * *Himachal Pradesh * * * *Shimla *Pahari
> East India * * *Maharashtra * * Mumbai *Marathi
> East India * * *Manipur Imphal *Manipuri
> East India * * *Meghalaya * * * Shillong * * * *Khasi, Jaintia and Garo
> East India * * *Mizoram Aizawl *Mizo and English
> East India * * *Nagaland * * * *Kohima *Ao, Konyak, Angami, Sema and Lotha
> East India * * *Orissa *Bhubaneswar * * Oriya
> East India * * *Punjab *Chandigarh * * *Punjabi
> East India * * *Sikkim *Gangtok Bhutia, Hindi, Nepali, Lepcha, Limbu
> East India * * *Tripura Agartala * * * *Bengali, Tripuri, Manipuri, Kakborak
> EAST INDIA * * *West Bengal * * Kolkata Bengali
> North India * * Arunachal Pradesh * * * Itanagar * * * *Miji, Apotanji, Merdukpen,
> Tagin,Adi, Honpa, Bangini-Nishi.
> North India * * Delhi * Delhi * Hindi
> North India * * Jammu and Kashmir * * * Srinagar * * * *Hindi
> North India * * Uttar Pradesh * Lucknow Hindi
> south India * * Andaman and Nicobar Islands * * Port Blair * * *Hindi
> south India * * Andhra Pradesh *Hyderabad * * * Hindi
> south India * * Karnataka * * * Bengaluru * * * Kannda
> south India * * Kerala *Thiruvananthapuram * * *Malayalam
> south India * * Lakshadweep * * Kavaratti * * * Tamil
> south India * * Puducherry * * *Puducherry * * *Tamil
> south India * * Tamil Nadu * * *Chennai Tamil
> west India * * *Dadra and Nagar Haveli *Silvassa * * * *Tamil
> west India * * *Daman and Diu * Daman * Marathi and Konkani
> west India * * *Goa * * Panaji *Marathi and Konkani
> west India * * *Gujarat Gandhinagar * * Gujarati
>
> '--------------------------------------------------------------------------*----------------------------
> Critria list
>
> Region *:..........................
> State * :..........................
> Capital :..........................
> Languages * * * :..........................
> ------------------------------------------------------------------------
>
> Criteria *List *should come *Option list box
>
> Based on above *Criteria *list * how can *do the Advanced Filter *you
>
> Please Help me *sir,
Take a look at Dependent Lists.
http://www.contextures.com/xlDataVal02.html
I think that will do what you want.
Similar Threads
