How to copy/paste with automatic filter
 

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


--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=518658

How to copy/paste with automatic filter
 

Maybe a macro could do this job