auto filter

[Neodubois]

Hi All,

I am working on a macro with an autofilter, would there be a way to have it filter the values one by one from one single column the values possibly beeing different every time

Thanks

[Bob Phillips]

Different is no problem, just link the filter to a cell value in VBA, but what does ... one by one .. mean?

[Neodubois]

Actually I would like to filter one column based on the first criteria than copy paste to another workbook, than go back and filter on the second criteria copy paste and so on


problem is I can not define which will be the criteria that can occur

[Bob Phillips]

IF you cannot define the criteria, it cannot work. You must mean something different to what you are saying.

[Neodubois]

the criteria can be up to 10 different codes, but I don't know which ones will be in the file every time I rfresh the file perhaps only 1 or all 10