How to copy/paste with automatic filter

[pmarques]

How to copy/paste (in different columns) with automatic filter maintaining the cells reference one example:

I have a column with a automatic filter that shows A4=0 ; A8=0 ; A10=0
i select this cells + copy than i try to past in other collum (the filter still active) and gives, example: C1=0 ; C2=0 ; C3=0 but i want to give the same result as the first ( C4=0 ; C8=0 ; C10=0) can this be done???

Thanks

[[email protected]]

Maybe a macro could do this job