shifting data in excel (logs)
 

I am creating a database of business contacts and details of the las
three times I have contacted them. I am doing this in Excel. Is ther
any way I can format my sheet so that when I start typing in the firs
column of the three previous contact details, the text that was in th
first cell moves to the second column, and the text in the second move
to the third, and the text in the third is removed from the database
Obviously when i start populating it for the first time there will b
no text in any of the three colums, but after a while it will be an
this woulod greatly improve functionality. Thank you for your hel

--
mr_chrisevan
-----------------------------------------------------------------------
mr_chrisevans's Profile: http://www.excelforum.com/member.php...fo&userid=3031
View this thread: http://www.excelforum.com/showthread.php?threadid=49975