Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Date
I am looking to create a schedule. I want to enter the first day of the
week on the first sheet and for it to fill in on the other sheets. I also want to be able to enter the names on the first sheet and have them auto copy onto the other sheets. I am going to be changing the names of the people I am scheduling on a weekly basis. I dont want to copy and paste it. I know that I can do that. It would be easier to have it auto copy. Can anyone help me? |
#2
|
|||
|
|||
Regardless you need to do some manual labour, you can do this with direct
linking i.e. Assume you put something in A1 and want it copied to the rest of the sheets, select the rest of the sheets, while selected click in the first selected sheet and the cell where you want the link, type =, click the first sheet and A1, press enter, right click any sheet and select ungroup -- Regards, Peo Sjoblom "Lyali" wrote in message ... I am looking to create a schedule. I want to enter the first day of the week on the first sheet and for it to fill in on the other sheets. I also want to be able to enter the names on the first sheet and have them auto copy onto the other sheets. I am going to be changing the names of the people I am scheduling on a weekly basis. I dont want to copy and paste it. I know that I can do that. It would be easier to have it auto copy. Can anyone help me? |
#3
|
|||
|
|||
Ok I think that I can get that taken care of. If I have to copy and paste
then so be it. I was just trying to do something different. :) What about the date thing? "Lyali" wrote: I am looking to create a schedule. I want to enter the first day of the week on the first sheet and for it to fill in on the other sheets. I also want to be able to enter the names on the first sheet and have them auto copy onto the other sheets. I am going to be changing the names of the people I am scheduling on a weekly basis. I dont want to copy and paste it. I know that I can do that. It would be easier to have it auto copy. Can anyone help me? |
#4
|
|||
|
|||
Dates are numerical (if you do it correctly), so to fill in dates you can
use =IF('Sheet1'!A1="","",'Sheet1'!A1+1) since one day equals 1 then you just need to add one and format as date -- Regards, Peo Sjoblom "Lyali" wrote in message ... Ok I think that I can get that taken care of. If I have to copy and paste then so be it. I was just trying to do something different. :) What about the date thing? "Lyali" wrote: I am looking to create a schedule. I want to enter the first day of the week on the first sheet and for it to fill in on the other sheets. I also want to be able to enter the names on the first sheet and have them auto copy onto the other sheets. I am going to be changing the names of the people I am scheduling on a weekly basis. I dont want to copy and paste it. I know that I can do that. It would be easier to have it auto copy. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto placement of date | Excel Discussion (Misc queries) | |||
auto dating after entering the first date | Excel Worksheet Functions | |||
assign auto number and auto date | Excel Discussion (Misc queries) | |||
auto entry of a date | Excel Worksheet Functions | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |