I put this code in the cell A1
* =IF($J$1=$K$1,K:K,0)*
and it show me in the *A1 * the data in the *k1*
so as you see in the code I limit the data in column K for end,*
(k:k)*
but my probelm is :
the code only print the data in the *K1* to the column *A *,I want it
to take all the data in the column K to *A* without copy down the code
to each cell.


--
nader
------------------------------------------------------------------------
nader's Profile: http://www.excelforum.com/member.php...o&userid=10881
View this thread: http://www.excelforum.com/showthread...hreadid=471309