Assign Multiple Macros to Drop Down List

I have a lot of data that I built macros to sort when you when to see certain categories.

I had it so if you wanted to see Portfolio A, you click a button and it sorts the list of 100 names into the 25 that are in Portfolio A, and etc for other Portfolios.

However, now I have too many buttons and I would rather be able to use a Drop Down List.

I want a drop down list with 10 names on it, where for each name that I choose from the list, it runs a different macro. Is this possible?

All I can figure it is how to assign 1 macro to the drop down list, which seems useless to me. How can I make each name on the list assigned to a macro?

Hello rem8223,

Use this macro as the one you attach to the drop down. Change the macro names Macro1, Macro2, etc. to the names of the macros you want to run.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Sincerely,
Leith Ross

Leith,

Thanks for this. I'll try it out.

I have a similar task but I don't know how to assign the macro to run on the drop down list. Can someone assist?