Hi All

My macro automatically runs autofilter and filters data with every filter
criteria I have set and moves them to separate sheets. But I want the macro
to automatically identify all the filter criteria in a given column and
filter out the data in separate sheets. I tried my best to find if excel
offers any such feature so that I can convert into a macro. But I could not
find any. If anybody can give any lead in this direction, it would be of
immense help.

Regards
Antony Juno