what column is the empty cell going to be in? Or is this a variable
that is unknown? Because you could do a loop to look for a empty cell
and then have it copy the data over? Is this what you are looking for?


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=482406