Ok guys!
Here it goes

Basically, I need the IF function to remain in the cell until th
argument is true. I dont know if I explain myself correctly:
I have two sheets, sheet1 is where I have all the data and the sheet
is where I run my IF funtion.
So basically the way it is set up is if in sheet1 I right retenu in
cell, the argument is true and is carried to sheet2. If the case i
empty, nothing happens. The difficulty that I am having is when I righ
"retenu" for example on line 17 it gets transfers in sheet2 also on lin
17. I want to transfer it to line 1. So it gets stacked one after th
other on sheet2. I dont want to have very long spaces.

Anyone knows how this can be done and what loops to use?

Thank

--
gek
-----------------------------------------------------------------------
geka's Profile: http://www.excelforum.com/member.php...fo&userid=2757
View this thread: http://www.excelforum.com/showthread.php?threadid=47157