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
Macros and Drop Down List
-
- Administrator
- Posts: 78237
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Macros and Drop Down List
Could you attach a small sample workbook (without sensitive information) that shows what your sheet looks like?
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 33
- Joined: 30 Nov 2017, 13:55
Re: Macros and Drop Down List
Hans,
Attached is a snippet of the list
Attached is a snippet of the list
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78237
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Macros and Drop Down List
See the attached version (now a .xlsm since it contains VBA code).
The code is in the Worksheet_Change event procedure of the worksheet.
The code is in the Worksheet_Change event procedure of the worksheet.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- Lounger
- Posts: 33
- Joined: 30 Nov 2017, 13:55
Re: Macros and Drop Down List
Hans,
You are a true wizard. Thank you so much.
You are a true wizard. Thank you so much.