Autofilter VBA Macro to filter out individual columns across entire workbook

Hello,

I'm trying to figure out how to write a bit of code to apply a couple filters across my entire workbook for specific text fields of data in specific columns.

The columns headers and associated filters I'm using on each independent sheet (via data validation) are the same.

Simply put...I'd like to have multiple buttons (for each filter I'd like to apply) on master sheet that when clicked filter the entire work for a specific text field in a specific column. To be clear - the master sheet does not have the same configuration as the working sheets and does not need to be filtered.

I'm able to get the first filter (Column N; text field = "Public") working using the code below:

Please Login or Register  to view this content.

But when I try to modify this code for my next filter (Column P; text field = "Active") the whole thing craps out and only shows the top row of each sheet where the header describing the filter criteria is located. Code used is below.

Please Login or Register  to view this content.

I'm sure there's a simple solution here but after 3 hours of googling and trying this and that - I need some help.

Thanks in advance for your time.

Regards,
Patrick

Hello prnetreba,

Welcome to the Forum!

This problem would be easier to sort out with acopy of your workbook.

To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.