Advance Filter with Multi Criteria
 

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,

Advance Filter with Multi Criteria
 

On Jul 21, 6:54*am, chandra sekaran 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.