Hello, I would be grateful if anyone could give a go at this problem I have:

To give you an idea of the columns I have in order from left to right:

1. Company Name
2. Contact's title/position (there are more often than not multiple contacts per company)
3. Many other columns that have vital information that needs to be kept tethered to the above categories, but I do not need to use them as criteria for my filter.

What I want to automate/create a macro to do:

1. Apply a filter to the "Contact's Title" of companies that have more than 6 contacts:
2. The filter needs to have a customizable base that allows me to filter out/in "Contact Title's" that contain input terms decided by the macro user.

The final goal:

1. Reduce the contacts of companies with more than 6 contacts to the 6 key personnel.
2. The six key personnel titles can be decided upon use by the user.

I am familiar with recording macros and pivot tables.

What I have been able to do:
1. I can filter out the companies with more than 6 contacts using a pivot table with only those two categories (Company Name and # of Contacts).
2. The problem with this is I cannot utilize the output companies from step one to repopulate a new pivot table that allows me to go through "Contact Titles" and allow the user to type inputs into this.

I really appreciate any help I can get.

Best Regards,
Eddie