Default Dropdown menu to isolate records

A couple options spring to mind.

You use a filter macro to check lines for the dropdown name and instantly hide all non-matching records. You could use a big shiny button for this.

Parts List - Autosort Macro.xlsm

I made this for a fellow from a trucking company. Type a word like truck or tire and hit the button.

Imagine this, but instead of a free entry box using a dropdown.


Or, you could use a second tab to filter only the results according to a dropdown menu. This would be a non-macro option but would significantly increase processing and file size due to the number of array formulas with 10,000 records.

If you're able to post a sample of your work, I can show you what type of formulas to use in conjunction with the data validation.

Here you go!

You will end up hiding column K, but I left it visible so you can see how it works.

Each formula in K checks if the name from the dropdown exists in the corresponding cell in A and just produces a True or False. The button does the filter for you.

The dropdown in B3 is where you choose a name. Then you click Show Results. The other button resets the filter.



Filter Macro for john.xlsm

It sounds like your macros may be disabled. When the workbook first opens, make sure you hit the enable macros button that should pop up.

Other places to enable macros are in the Trust Center, or under File on the information page, or on the Developer tab under Macro Security.

Maybe this would work for you:

Have you saved a copy and run it from there?

Both of those work fine on a different computer. The one I need to use must have Macros disabled outside Excel some way I can't access.

I'm reluctant to apply it to my own document, since I don't see why it should work if Daffodil's didn't. And I know Daffodil's is designed perfectly.


Or, you could use a second tab to filter only the results according to a dropdown menu. This would be a non-macro option but would significantly increase processing and file size due to the number of array formulas with 10,000 records.

Is this the same as the 'Sort and Filter' button, top right of Home tab in Excel 2010?