some of your reply seems to be missing do you mean change the variable
cell to i there for the code would resemble

If Range("AE1") = i Then
i.Offset(0, 1) = Range("AD1")

?

if this is right how do you make i (cell a1) change to the next cell a2
all the way down to the last cell in the column, to save time ending the
loop when the acenario is true?

range ae1 and ad1 are absoulte referances but a1 is relative and will
need to change down the column and finally when the loop ends ad1 will
then be sent to the cell NEXT to the final referance point, hence the
offset code

thanks for the reply


--
short_n_curly
------------------------------------------------------------------------
short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576
View this thread: http://www.excelforum.com/showthread...hreadid=384154