AutoFilter

[Guest]

Hello,

I am trying to write a piece of code that filters a data set on various
values. I am looping through each value to be filtered first. If there are
items returned from the filter then I want to only copy the filtered items to
a new worksheet without the column headings and also compute an average for a
particular column of values from the filtered range. Any ideas or thoughts?

Thanks,
Mike

 

[WhytheQ]

Is this something where you would normally use Excel's built-in
autofilter - if so then using this in your code, rather than looping
through each of the rows, will be much quicker (if you have lots of
criteria then the autofilter route isn't so hot)

J

 

[Guest]

Yes, I would normally be using the Autofilter command witin Excel. I intened

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy5.htm

See the tips below the first example