P
per.carlsson
I'm trying to create a personell rooster chart with a 6 week cycle.
The workbook I have looks like this:
date day week roosterweek month Name1
Name2 Name 3 Name4
Patrik Gullan Debra Simon 01.01.2007
1 1 1 1 8-15
9-17 15-23 23-08
functions used
weekday() Weeknr() month()
For the rooster week i made a table of the week numbers and the tooster
weeks and used a hlookup function
weekno rooster week
1 1
2 2
3 3
4 4
5 5
6 6
7 1
What I want to do is to transform the table with the names and times
into a data list with names in one coloumn, times in one coloum and so
on.
I still want the raw data to be in the format as described above, but
if i make a change in times, i want that change to reproduce to the
whole year.
I want this in the data list format so my emplyees can use a pivot
table. That way the raw data is always protected and they cannot
accidentily screw it up.
Is there a smart way to do this?
I'm a new beginner to all this.
The workbook I have looks like this:
date day week roosterweek month Name1
Name2 Name 3 Name4
Patrik Gullan Debra Simon 01.01.2007
1 1 1 1 8-15
9-17 15-23 23-08
functions used
weekday() Weeknr() month()
For the rooster week i made a table of the week numbers and the tooster
weeks and used a hlookup function
weekno rooster week
1 1
2 2
3 3
4 4
5 5
6 6
7 1
What I want to do is to transform the table with the names and times
into a data list with names in one coloumn, times in one coloum and so
on.
I still want the raw data to be in the format as described above, but
if i make a change in times, i want that change to reproduce to the
whole year.
I want this in the data list format so my emplyees can use a pivot
table. That way the raw data is always protected and they cannot
accidentily screw it up.
Is there a smart way to do this?
I'm a new beginner to all this.