Excel Updateing Information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnM - 03 Aug 2007 14:36 GMT

I have a table with field headings of days of the week and dates
In each column I enter numbers or text of what is happening on that day
I can get the headings to change automatically using =Today() in the first
cell but then I have to manually Copy and Paste the rest of the data
Is there a way I can get this to happen as the date changes

Thanks for any help

Signature

JohnM

Reply to this Message

Sean Timmons - 03 Aug 2007 18:46 GMT

Not sure what data is being copied and pasted. If you want day of the week to
change, you can also use =today() and format the cell as day.

> I have a table with field headings of days of the week and dates
> In each column I enter numbers or text of what is happening on that day
[quoted text clipped - 3 lines]
>
> Thanks for any help

Reply to this Message

JohnM - 04 Aug 2007 09:46 GMT

my atble is set out
mon/tue/wed/thu/fri/sat/sun
date
then info for each day

When the date changes it becomes
tue/wed/thur/fri/sat/sun/mon
the dates move accordingly
the information for each day however has to be moved manually

Signature

JohnM

> Not sure what data is being copied and pasted. If you want day of the week to
> change, you can also use =today() and format the cell as day.
[quoted text clipped - 6 lines]
> >
> > Thanks for any help

Reply to this Message

Roger Govier - 04 Aug 2007 11:41 GMT

Hi John

If you made A1 hold the date then enter in B1
=$A$1+COLUMN()-2
Copy this across through C1:H1 and format cells Custom ddd
This will provide the days of the week, relative to the date entered in A1

Then each time you want to move things across, Insert a new column at B, and
copy C1 to B1
Record a macro as you do this, then run it whenever you need.

Signature

Regards
Roger Govier

> my atble is set out
> mon/tue/wed/thu/fri/sat/sun
[quoted text clipped - 18 lines]
>> >
>> > Thanks for any help

Reply to this Message

JohnM - 04 Aug 2007 13:28 GMT

Thankyou for that but I still ahve the same problem - I am not explaining
properly - I shall try better
My table looks

Mon Tue Wed Thu Fri
1/8 2/8 3/8 4/8 5/8

Boat Heli Heli
1 2 1

I can get the Day and Date to move put this what happens

Tue Wed Thu Fri sat
2/8 3/8 4/8 8/8 6/8
Boat Heli Heli
1 2 1

The information should show No Boat and the Heli's on 2 & 4/8

I hope that is clearer

Signature

JohnM

> Hi John
>
[quoted text clipped - 29 lines]
> >> >
> >> > Thanks for any help

Reply to this Message

Rate this thread: