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=518659

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" wrote:


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=518659

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

------------------------------------------------------------------
CLR Wrote:
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.


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

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 wrote:

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

------------------------------------------------------------------
CLR Wrote:
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.

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

--

Dave Peterson

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

[b]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
--------------------------------------------------------------
Dave Peterson Wrote:
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 wrote:

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

------------------------------------------------------------------
CLR Wrote:
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.

--
pmarques

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

--

Dave Peterson


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

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

[b]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
--------------------------------------------------------------
Dave Peterson Wrote:
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 wrote:

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

------------------------------------------------------------------
CLR Wrote:
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.

--
pmarques

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

--

Dave Peterson


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