Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revised: help with calculating 3 part function in excel | Excel Worksheet Functions | |||
Revised dates in excel | New Users to Excel | |||
Worksheet Names (Revised) | Excel Discussion (Misc queries) | |||
MacroHelp - Revised submission | Excel Discussion (Misc queries) | |||
n or U Revised ? | Excel Worksheet Functions |