how to write macro after autofilter is applied

[emre]

I am trying to extrude out 4 values(number of values, min of values, average
of values and max of values) out of several readings of several
parameters(stuff related to water characteristics) This takes lots of time. I
want some automation.
What i am doing manuıally is
apply autofilter
choose parameters one by one from the drop list.
select all values holding draggin with the mouse.
use the status bar functions(countnumber, min, ave, max) to display the the
values i am looking for.
manually write these 4 values to an individual worksheet.
advance to the next parameter in droplist. and so on.

writing a formula for these 4 values will not work in autofilter mode since
the formulas take account of everything selected plus hidden cells thus gives
wrong results.

can a macro automate this steps?

 

[CLR]

Yes, a macro can be written to do just about anything you want it to, and if
these actions are repeated frequently then that is the course you should
take. The details are very specific to your application tho. But in the
meantime, something that might help a little is that when you first obtain
the AutoFilter results, then copy and paste them over to another sheet. Now
you can apply formulas to that sheet and they will only affect the FILTERED
data.........

hth
Vaya con Dios,
Chuck, CABGx3

 

[emre]

i have already tried copy pasting- it works, but it is still far from
automation. i need a macro that can read all autofilters droplist elements
corresponding data.