| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Moving Data Automaticaly
Can you help
I have a table (part shown below) the Date and Day moves automaticaly to left at midnight - is it possible to get the rest of the data to move as well 25-Nov 26-Nov 27-Nov 28-Nov Sun Mon Tue Wed 07:00 07:00 TBA on off on off on off on off 1 1 1 1 1 1 1 1 1 1 1 1 1 1 -- JohnM |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Moving Data Automaticaly
Please explain meaning of "date and day MOVES to left"
Are you using conditionally formatting to highlight the cell with the current date? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JohnM" wrote in message ... Can you help I have a table (part shown below) the Date and Day moves automaticaly to left at midnight - is it possible to get the rest of the data to move as well 25-Nov 26-Nov 27-Nov 28-Nov Sun Mon Tue Wed 07:00 07:00 TBA on off on off on off on off 1 1 1 1 1 1 1 1 1 1 1 1 1 1 -- JohnM |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Moving Data Automaticaly
No I have =today() in the first date box and then the cell number + 1 in the
rest - as the date changes so everything moves across -- JohnM "Bernard Liengme" wrote: Please explain meaning of "date and day MOVES to left" Are you using conditionally formatting to highlight the cell with the current date? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JohnM" wrote in message ... Can you help I have a table (part shown below) the Date and Day moves automaticaly to left at midnight - is it possible to get the rest of the data to move as well 25-Nov 26-Nov 27-Nov 28-Nov Sun Mon Tue Wed 07:00 07:00 TBA on off on off on off on off 1 1 1 1 1 1 1 1 1 1 1 1 1 1 -- JohnM |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Moving Data Automaticaly
Copy the row with the date down to the next row; format the new cell with
Custom Format of dddd to give Sunday, Monday,.... In A3 enter =NOW() and format as time Not sure what else you want. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JohnM" wrote in message ... No I have =today() in the first date box and then the cell number + 1 in the rest - as the date changes so everything moves across -- JohnM "Bernard Liengme" wrote: Please explain meaning of "date and day MOVES to left" Are you using conditionally formatting to highlight the cell with the current date? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JohnM" wrote in message ... Can you help I have a table (part shown below) the Date and Day moves automaticaly to left at midnight - is it possible to get the rest of the data to move as well 25-Nov 26-Nov 27-Nov 28-Nov Sun Mon Tue Wed 07:00 07:00 TBA on off on off on off on off 1 1 1 1 1 1 1 1 1 1 1 1 1 1 -- JohnM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Turn vertical data to horizontal data automaticaly | Excel Worksheet Functions | |||
| How do I copy all cell data between sheets automaticaly? | Excel Discussion (Misc queries) | |||
| moving data to non autofarmatted book changes data- Why? | Excel Discussion (Misc queries) | |||
| moving data in excel without deleting existing data | Excel Discussion (Misc queries) | |||
Linear Mode
