Filter columns by typing text in a search box?

How familiar are you with VBA? I just did a project exactly like that today: http://www.excelforum.com/excel-prog...ed-filter.html

You would just need to change the relevant parameters (the worksheet name you're searching in, firstrow, firstcolumn, a few ranges, a few .Offset arguments, Range arguments, etc.), insert a row to place a Macro button (that would be located in row 3), and insert a blank row for search fields (row 4). Most of the work done to develop the code from the macro I posted in the link above is copy and paste. I try to be as explicit as possible when I code, so you should be able to solve this problem with little-no guidance beyond the above post.

Let me know if you have any questions.

Mickey,
yep... that's what my solution does. It wouldn't be too difficult to create a search based on an arbitrary number of criteria separated by commas (such as: "A, B, C").


VBA can be challenging if you have no guidance. I'll be happy to break it down for you what you can do in 10 easy-to-follow tasks to help me finish this for you. Although it doesn't seem like you're doing much, it will help me because a lot of the work I'll be doing is copying and pasting.

If you complete the following steps, I'll take care of it for you before I go to bed tonight (or the following day in which you complete it).

Step 1: Open up the workbook you uploaded.
Step 2: Open up the VBA editor (this may sometimes be done by hitting: Alt + F11)
Step 3: Create a new module (right click on the Project - VBA Project window - click Insert - click New Module): http://www.cpearson.com/excel/codemods.htm or https://www.youtube.com/watch?v=KHO5...3akx_gFMnpxTN5
Step 4: Copy and Paste my code that is shown in the post I listed above into the module you created
Step 5: Delete all macros except: Sub FilterConsequence() and Sub resetwb()
Step 6: Change each line with a comment: 'change "E" when changing macro to the right of the line of code to have an "A" instead of a "G" in the Range argument(WS_Raw.Range("G" & firstrow) should be WS_Raw.Range("A" & firstrow) when you're done)
Step 7: Change the line with a comment: 'change 5 when changing macro (though... this probably doesn't matter) to have a 1 instead of 7 in the Cells argument
Step 8: Change the line with a comment: 'change offset when changing macro so that RNG_DisDat.Offset(0, -6).Resize(1, DatLen_cl)) is RNG_DisDat.Resize(1, DatLen_cl))

Step 9: Insert two blank lines between your drop down list and where the data begins (one for the search button and one for the test you'll search for)
Step 10: Upload the document to the forum

And that's it! I'll take it from there...