I have a worksheet which I regularly autofilter filter for
each unique value in column C and then copy the result of
each such filter to another worksheet. Whn I do an
autofilter, Excel automatically displays all values and I
simply have to choose each value. I would like to automate
this process with a amcro, but do not know how to
determine all the various values that I need to filter on
and once I have such values, how do I put these in a loop
as criteria for each pass of the loop.

Any help would be greatly appreacited.

Many thanks in advance.

Mark