Create Filter based on users selection

[deante]

I am creating an application for my company that is a parts list. The goal is for maintenance techs to find part numbers quickly rather than looking in a manual.

I have a long excel file that is has the following headings:

Line MACHINE Area DRAWING # PART # Description


I want to create combo boxes that a user can select a line and machine area and it automatically filters the list so that only the parts for that particular area and line are displayed. I can create the macro to filter the list but can not create the combo boxes, without repeating the values for options.

Thanks in Advance

Deante

 

[SkipVought]

Hi,

You can use Advanced Filter to create a unique list of items. Leave CRITEIA blank and Copy to another location. Use that Unique list as the ListFillFange for your ComboBox.

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

I sent too quickly.

However, I prefer to use MS Query, Using MS Query to get data from Excel faq68-5829, with SQL like this...

Select Distinct Machine From [Sheet1$]

You only need ADD the querytable One Time. After that, all you need to is Refresh the QueryTable if your source data changes.

I use Dynamic Named Ranges, How can I rename a table as it changes size faq68-1331, to name my lists and column ranges in tables, so that when my ListFillRange changes, the Named Range will always reflect the correct range.


Skip,
[sub]
[red][/red]
[/sub]