Combining Dynamic Search Filters

[DMDComposer]

Hi,

I'm trying to create a database for my music ideas. I'd like to be able to search each individual column and narrow down the search results. I've achieved this using some dynamic filters and VBA coding I found from researching online.

What I'm trying to figure out now is if there is a way to combine my search dynamic filters so I can search One column & a second column and have them work off of each other. For example in my excel doc:

Search tempo = Adante
&
Search Mood = Happy

or one of the numerous variations of this between my columns. Searching both will narrow the results of the parameters that fit those requirements. Like an "and" or "or" function I suppose?

Here is my vba code here for my sheet.

Please Login or Register  to view this content.

Any one have any thoughts on how to achieve this or where to look and learn? I'm a complete novice on coding and only found this VBA code through some tutorial online. I'd attach my excel but the forum attachemnt isn't working for me atm.

Here is a pic of my excel so you may get the gist of it.

excel_snippet.jpg

Thanks!

[bakerman2]

The attachment icon doesn't work. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.