Macro to AutoFilter Excel DB

EE Professionals,

I have a worksheet that has 4 columns and an unlimited number of rows.  The first, second and third columns have redundent data in order for me to actually create a table with Parent Child relationships (that's why I have redundency in Columns A, B and C).  I have a Macro that EE Professional  I could put a filter on each Column, so I can collapse the data table to work only on a particular section of code at a time but I'm looking for a more "esthetic" way of presenting the selection.   The current sheed has a way to auto add records and then auto sort using a Form (written by EE Professional Epaclm (Curt))

How would I write a complementary macro that can do the same thing a filter can do by presenting a Form or Text Box, selecting the section and then having it filter or collapse the appropriate section?  I also have to have a macro to reexpand it back to display all.

Thank you in advance; sample attached.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieAnalyst Assistant Commented:
What it you want to filter on and which column is to be filtered?
Curt LindstromCommented:
Is this what you want?

However, using the Auto filter will achieve exactly the same results.

Bright01Author Commented:

Almost!  Two things, when you select a filter, can the other filters be made to only display in the dropdown, those selections that are available under the filter selected?  This may be too complex to do.  Second, when you try to clear the Filters (selecting 2 or more) it doesn't clear the list boxes.

What do you think?  Changable?

Curt LindstromCommented:
1st question: it may be possible but as you say it may be a bit complicated and I don't think I have the time to attempt that one.

2nd question, Yes it can be done as it's done in the attached file.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:

Outstanding!  Much thanks.  I'll look at the details today and learn from your code.  Really appreciate it.  I'll try to ask a related question later on this to try to see if there is a way to limit the choices.... still...may be too complex for an EE question.  I can use what you have given me.  

Again, "thank you"!!!

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.