Filter question

[Monarchs]

I want to do a macro that would filter a column with each criteria available in that column one at a time

It would then get data accroding to each filt.

I was looking for something like:

For each criteria in ???

Next criteria

Thanks for your help.

[RobDog888]

Welcome to the Forums.

Could you be a little more descriptive of what your trying to do?

For the most part, you can record a macro doing the action you want to
program. Then when your done, stop recording and check the code
generated in the Module in the VBA IDE.

[Daniel McCool]

I think he want's to filter a column for all possible criteria using a dynamic function and be able to do something with the filtered results.

[Monarchs]

That's exactly it Daniel McCool.

[Daniel McCool]

Write a loop to make your own criteria in an array.