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