In C3 type: =IF(A2<"",A1,"")
In C4 type: =IF(A2<"",A2,"")

Without knowing your layout for other cells to copy to I can't advise
as to Absolute Referencing but bear it in mind when adapting it to your
needs.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=400572