Hello,

i have used auto filter using the following code
Sheets("summary").Range("$A$1:$BY$16544").AutoFilter Field:=myfield, Criteria1:=mycrit1 _
        , Operator:=xlAnd, Criteria2:=mycrit2
this works. however, i need to copy only visible cells in column A to another worksheet ( say, starting from B1 in Sheet4)

Thanks