software

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: www.excelforum.com/member.php...oamp;userid=25110
View this thread: www.excelforum.com/showthread...hreadid=518659You 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
quot;pmarquesquot; wrote:

gt;
gt; How to copy/paste (in different columns) with automatic filter
gt; maintaining the cells reference one example:
gt;
gt; I have a column with a automatic filter that shows A4=0 ; A8=0 ; A10=0
gt;
gt; i select this cells copy than i try to past in other collum (the
gt; filter still active) and gives, example: C1=0 ; C2=0 ; C3=0 but i want
gt; to give the same result as the first ( C4=0 ; C8=0 ; C10=0) can this be
gt; done???
gt;
gt; Thanks
gt;
gt;
gt; --
gt; pmarques
gt; ------------------------------------------------------------------------
gt; pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
gt; View this thread: www.excelforum.com/showthread...hreadid=518659
gt;
gt;


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

------------------------------------------------------------------
CLR Wrote:
gt; You would have to copy the entire column, before filtering, and include
gt; both
gt; columns in the filter selection area, to get the results you want.--
pmarques
------------------------------------------------------------------------
pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
View this thread: www.excelforum.com/showthread...hreadid=518659Can 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:
gt;
gt; But I just want to copy the filtered cells.
gt; if there is example: A1=2 ; A3=24 they shouldn't be copyed...
gt;
gt; ------------------------------------------------------------------
gt; CLR Wrote:
gt; gt; You would have to copy the entire column, before filtering, and include
gt; gt; both
gt; gt; columns in the filter selection area, to get the results you want.
gt;
gt; --
gt; pmarques
gt; ------------------------------------------------------------------------
gt; pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
gt; View this thread: 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 quot;_
quot;represents blank cell)
C
_
_
_
0
_
_
_
0
_
0

I´ve tried past special... no success....
Thanks for the interess
--------------------------------------------------------------
Dave Peterson Wrote:
gt; Can you sort both lists so that they're in the same order, then just
gt; copy from a
gt; contiguous area to a contiguous area?
gt;
gt;
gt;
gt; pmarques wrote:
gt; gt;
gt; gt; But I just want to copy the filtered cells.
gt; gt; if there is example: A1=2 ; A3=24 they shouldn't be copyed...
gt; gt;
gt; gt; ------------------------------------------------------------------
gt; gt; CLR Wrote:
gt; gt; gt; You would have to copy the entire column, before filtering, and
gt; include
gt; gt; gt; both
gt; gt; gt; columns in the filter selection area, to get the results you want.
gt; gt;
gt; gt; --
gt; gt; pmarques
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; pmarques's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25110
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=518659
gt;
gt; --
gt;
gt; Dave Peterson--
pmarques
------------------------------------------------------------------------
pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
View this thread: 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 quot;_
quot;represents blank cell)
C
_
_
_
0
_
_
_
0
_
0

I´ve tried past special... no success....
Thanks for the interess
--------------------------------------------------------------
Dave Peterson Wrote:
gt; Can you sort both lists so that they're in the same order, then just
gt; copy from a
gt; contiguous area to a contiguous area?
gt;
gt;
gt;
gt; pmarques wrote:
gt; gt;
gt; gt; But I just want to copy the filtered cells.
gt; gt; if there is example: A1=2 ; A3=24 they shouldn't be copyed...
gt; gt;
gt; gt; ------------------------------------------------------------------
gt; gt; CLR Wrote:
gt; gt; gt; You would have to copy the entire column, before filtering, and
gt; include
gt; gt; gt; both
gt; gt; gt; columns in the filter selection area, to get the results you want.
gt; gt;
gt; gt; --
gt; gt; pmarques
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; pmarques's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25110
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=518659
gt;
gt; --
gt;
gt; Dave Peterson--
pmarques
------------------------------------------------------------------------
pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
View this thread: www.excelforum.com/showthread...hreadid=518659