How to Automatically Move Cell datato adjacent cell..
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 |
How to Automatically Move Cell datato adjacent cell..
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 |
All times are GMT +1. The time now is 08:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com