Hi,
I have a worksheet in which there have some 14 rows. I have attached the sample file for reference.
I need a userform in which some8 combo boxes required which is marked yellow color.
When i will select 1st combo box of “A” column for ex. “Branch Office” only Branch records will be shown in List Box like “Sales Office”. When select “All” from drop down total records will be shown.
2nd drop down is for “B” column where State names are mentioned. When i will select a State Name the particular state records will be shown in the list box under Branch Office / Sales Office.
All the records will be shown as per Data>Filter.
When i select Branch Office, State, Zone, Branch Status & Agreement Status the same data will filtered and shown in the list box. That particular data when i click a retrieve button it will copy my existing sheet named “Status”.
I may select 2/3/5 filters at a time as per requirement. Please help. Thanks.
List Box Data.xlsxList Box Data.xlsx
Bookmarks