Well here's my situation.

On first column is customer name(A1) next is Date last called (B1).
How can I automatically move the data in B1 to C1 if I enter a new
"date last called"
and so on so after a while Row 1 is getting longer with the "date last
called" is always on (B1)?

I hope you all understand what I mean.

Thanks.


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=476687