Record a macro while you are doing this, select the range and press F5,
special and then visible cells only, copy and and paste

--

Regards,

Peo Sjoblom

"Richard Latter" wrote in message
om...
Hello All,

I am currently filtering a list using the Autofilter function within
Excel. Great! However, I would like to produce a Summary Report in a
seperate worksheet based on the results of the filter. Does anyone
know a method of how to obtain criteria on which the Autofilter is
currently filtering on.

Eg. If I filter a column based on say the word "EDGE", how can you
automatically, obtain this from the autofilter....

Many thanks in advance,

Richard