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

 

[Guest]

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

 

[pmarques]

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

------------------------------------------------------------------

 

[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?

 

[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
--------------------------------------------------------------

 

[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
--------------------------------------------------------------