Excel Updating Information Revised
Sorry did fully explain my question
What I want to happen is that the coulmns move to the left as the date changes ie Mon/Tue/Wed/Thu/Fri/Sat/Sun when the date changes to next day columns become Tue/Wed/Thu/Fri/Sat/Sun/Mon all the information moving to the left also -- JohnM |
Excel Updating Information Revised
Can't you just delete the first column of days by highlighting the
column and Edit | Delete? - the other columns will move to the left to close the gap. Pete On Aug 3, 2:50 pm, JohnM wrote: Sorry did fully explain my question What I want to happen is that the coulmns move to the left as the date changes ie Mon/Tue/Wed/Thu/Fri/Sat/Sun when the date changes to next day columns become Tue/Wed/Thu/Fri/Sat/Sun/Mon all the information moving to the left also -- JohnM |
Excel Updating Information Revised
Thanks for the suggestion but unfortunately not because I would end up with
no days left and it is a continious process -- JohnM "Pete_UK" wrote: Can't you just delete the first column of days by highlighting the column and Edit | Delete? - the other columns will move to the left to close the gap. Pete On Aug 3, 2:50 pm, JohnM wrote: Sorry did fully explain my question What I want to happen is that the coulmns move to the left as the date changes ie Mon/Tue/Wed/Thu/Fri/Sat/Sun when the date changes to next day columns become Tue/Wed/Thu/Fri/Sat/Sun/Mon all the information moving to the left also -- JohnM |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com