Multi Select List Box based on Advanced Filter

[chandra sekaran]

Dear all,

I need vba code for Multi select list box based on advanced filter
here with attached samples file. It has two sheets , one is data
sheet another output sheet , when select multiselect list box
based out sheet data will be come automatically pls help sir,

Regards
Chandru
==================================================================================
Data sheet
A B C D
------------------------------------------------------------------------------------
Region State Capital Languages
-----------------------------------------------------------------------------------
Central India Bihar Patna Hindi
Central India Chandigarh Chandigarh Hindi
East India Assam Dispur Assamese
East India Haryana Chandigarh Hindi
East India Nagaland Kohima Ao, Konyak, Angami, Sema
and Lotha
East India Orissa Bhubaneswar Oriya
North India Arunachal Pradesh Itanagar Miji, Apotanji,
Merdukpen, Tagin,Adi, Honpa, Bangini-Nishi.
North India Delhi Delhi Hindi
south India Karnataka Bengaluru Kannda
south India Kerala Thiruvananthapuram Malayalam
west India Goa Panaji Marathi and Konkani
west India Gujarat Gandhinagar Gujarati
=================================================
Sheet 2
=================================================
Criteria List box with multi select
option *

Region :South India
State :
Capital :
Languages:Tamil
********************************************************************************
Out Put details
Region State Capital Languages

 

[Ms-Exl-Learner]

Try Pivot Table.