How to copy/paste with automatic filter

P

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
 
C

CLR

You would have to copy the entire column, before filtering, and include both
columns in the filter selection area, to get the results you want.

Vaya con Dios,
Chuck, CABGx3
 
P

pmarques

But I just want to copy the filtered cells.
if there is example: A1=2 ; A3=24 they shouldn't be copyed...

------------------------------------------------------------------
 
D

Dave Peterson

Can you sort both lists so that they're in the same order, then just copy from a
contiguous area to a contiguous area?
 
P

pmarques

In the example that I give there is only one initial list
A[/B]

3
34
5
0
2
45
33
0
9
0

THEN I SELECT FILTER = 0


0
0
0
0

then select+copy+ paste in C the desired result is ( where "
"represents blank cell)

_
_
_
0
_
_
_
0
_
0

I´ve tried past special... no success....
Thanks for the interess
--------------------------------------------------------------
 
P

pmarques

In the example that I give there is only one initial list
A[/B]

3
34
5
0
2
45
33
0
9
0

THEN I SELECT FILTER = 0

A
0
0
0
0

then select+copy+ paste in C the desired result is ( where "_
"represents blank cell)
C
_
_
_
0
_
_
_
0
_
0

I´ve tried past special... no success....
Thanks for the interess
--------------------------------------------------------------
 
Top