Thread: AutoFilter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default AutoFilter

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