A
Alsager
I have been asked by my boss to put together a form that creates
timetable and I can't figure out for the life of me how to make i
work.
It's just two sheets. If it were figures I think I could cope, but
seem to have encountered a mental block - any help would be mos
appreciated!
Sheet one:
Left hand column contains the names of all the managers, top row hold
the days of the week. The rows for each day are for the input o
particular shifts (9 in total).
Sheet two:
What she wants is a timetable here; days across the top again, but th
shifts in the left column, so the managers' names appear in th
relevant fields.
So please, any tips on how to do this, or a point in the direction of
good book so I can figure it out would be wonderful. I doubt I'll us
excel much again (my boss thinks that because I can work photoshop
office would be easy...) but I'd like to get this running.
I am using Office 2000 on XP.
Thanks in advance,
Marti
timetable and I can't figure out for the life of me how to make i
work.
It's just two sheets. If it were figures I think I could cope, but
seem to have encountered a mental block - any help would be mos
appreciated!
Sheet one:
Left hand column contains the names of all the managers, top row hold
the days of the week. The rows for each day are for the input o
particular shifts (9 in total).
Sheet two:
What she wants is a timetable here; days across the top again, but th
shifts in the left column, so the managers' names appear in th
relevant fields.
So please, any tips on how to do this, or a point in the direction of
good book so I can figure it out would be wonderful. I doubt I'll us
excel much again (my boss thinks that because I can work photoshop
office would be easy...) but I'd like to get this running.
I am using Office 2000 on XP.
Thanks in advance,
Marti