Automatically set autofilter criteria based on name of column?

[kestefon]

There is a report that I run on a daily basis that uses the same autofilter criteria each time: Any column named "Unweighted" has to be greater than or equal 30, and any column named "Index" has to be greater than or equal to 100. I'm trying to figure out how to set those criteria instantly with a press of a button.

Unfortunately, this report sometimes has more data or less data, so my subroutine needs to be dynamic.

I know that I could create variables and manually step through until I reach a blank, but I'm wondering if there is a better way to do this? I'm just brainstorming here, but is it possible to tell VBA to identify all of those "Unweighted"/"Index" columns by name? i.e. "If an autofilter column is called "Unweighted", apply a >=30 filter", etc.

This attachment should clarify:
Example Data - Autofilter.xlsx

[p24leclerc]

try this macro:
There must be no empty columns in your table.
Titles are in row 3.
It self-adjusts to data length.

Please Login or Register  to view this content.

[kestefon]

That is PERFECT. Thanks!

[kestefon]

Pierre, can you explain a bit about what you're doing with all of those IF statements? I'll have to customize a bit and want to understand what exactly you did.

[p24leclerc]

Here you are:

Please Login or Register  to view this content.

If you need some more help do not hesitate to ask