Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Cover sheet which logs data entered | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Shifting data down | Excel Programming | |||
Shifting Data Right Within A Range | Excel Programming |