Moving Data Automaticaly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnM - 25 Nov 2007 09:40 GMT

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

Signature

JohnM

Reply to this Message

Bernard Liengme - 25 Nov 2007 13:43 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Can you help
>
[quoted text clipped - 16 lines]
> 1 1
> 1 1

Reply to this Message

JohnM - 25 Nov 2007 13:59 GMT

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

Signature

JohnM

> Please explain meaning of "date and day MOVES to left"
> Are you using conditionally formatting to highlight the cell with the
[quoted text clipped - 20 lines]
> > 1 1
> > 1 1

Reply to this Message

Bernard Liengme - 25 Nov 2007 20:23 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> No I have =today() in the first date box and then the cell number + 1 in
> the
[quoted text clipped - 26 lines]
>> > 1 1
>> > 1 1

Reply to this Message