Data filtering using combo box, data validation list or drop down list

cthompson

Board Regular
Joined
Jan 31, 2011
Messages
80
Hi All

I am attempting to build a form that utilizes a large list of data approximately of 40k lines. I want to use the data validation list (or any drop down list, combo box, etc) that will filter this data to be selected by a user.

For example selecting the department would filter the buildings that are associated with that department, then select a building and filter the rooms dependent on what building is selected.

If you selected Dept DF, there are 25 building associated with that department. Then depending of the building selected filter on the rooms based on the building. Once the room is selected display the group coded and project from the 3 filters set previously. The other wrinkle is to eliminate duplicates in the department and buildings.

Using the standard filter in the example below provides the same results below but I wanted to display it in a user form based on a drop down list or a data validation list. Also the standard filter eliminates all duplicates and only displays the unique elements up to 10k values. Any suggestions or ideas would be appreciated.
Chris



-- removed inline image ---

<colgroup><col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> </colgroup><tbody>
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]

</tbody>
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top