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

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




On 31 May, 13:37, Mike wrote:
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

Yes, I would normally be using the Autofilter command witin Excel. I intened
on using the autofilter in my code. The loop will actually be used since I
have about 12 different filter criteria values. I hope this helps. Thanks.

"WhytheQ" wrote:

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




On 31 May, 13:37, Mike wrote:
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

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

See the tips below the first example

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mike" wrote in message ...
Yes, I would normally be using the Autofilter command witin Excel. I intened
on using the autofilter in my code. The loop will actually be used since I
have about 12 different filter criteria values. I hope this helps. Thanks.

"WhytheQ" wrote:

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




On 31 May, 13:37, Mike wrote:
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