Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Updateing Information
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 -- JohnM |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Updateing Information
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. "JohnM" wrote: 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 -- JohnM |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Updateing Information
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 -- JohnM "Sean Timmons" wrote: 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. "JohnM" wrote: 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 -- JohnM |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Updateing Information
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. -- Regards Roger Govier "JohnM" wrote in message ... 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 -- JohnM "Sean Timmons" wrote: 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. "JohnM" wrote: 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 -- JohnM |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Updateing Information
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 -- JohnM "Roger Govier" wrote: 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. -- Regards Roger Govier "JohnM" wrote in message ... 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 -- JohnM "Sean Timmons" wrote: 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. "JohnM" wrote: 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 -- JohnM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Information from Excel to a PDA. | Excel Discussion (Misc queries) | |||
what is the information box in excel | Excel Discussion (Misc queries) | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
Updateing formulas | Excel Worksheet Functions | |||
Pivot Not Updateing | Excel Worksheet Functions |