I think if you highlight B1 and RightMouse, Insert, Shift Cells Right,
and then enter your new date in B1
you will have what you need.



cardingtr Wrote:
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.


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