shifting data in excel (logs)

M

mr_chrisevans

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top