Macros and Drop Down List

bohi59
Lounger
Posts: 33
Joined: 30 Nov 2017, 13:55

Macros and Drop Down List

Post by bohi59 »

I have a spreadsheet with several hundred Suppliers and their respective certification. Is it possible to create a Drop Down List where you choose a number that represents a specific Certification then a Macro will basically filter all those with the same Certification? I can filter for the specific Cert I want to see but management would like a button to see just those suppliers that are IATF 16949 or ISO 9001.

Thanks,
Bob

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Macros and Drop Down List

Post by HansV »

Could you attach a small sample workbook (without sensitive information) that shows what your sheet looks like?
Best wishes,
Hans

bohi59
Lounger
Posts: 33
Joined: 30 Nov 2017, 13:55

Re: Macros and Drop Down List

Post by bohi59 »

Hans,

Attached is a snippet of the list
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Macros and Drop Down List

Post by HansV »

See the attached version (now a .xlsm since it contains VBA code).
The code is in the Worksheet_Change event procedure of the worksheet.

Cert List.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

bohi59
Lounger
Posts: 33
Joined: 30 Nov 2017, 13:55

Re: Macros and Drop Down List

Post by bohi59 »

Hans,

You are a true wizard. Thank you so much. :smile: