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?
|