problem with print data in the all column
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 |
All times are GMT +1. The time now is 07:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com