L
lassang01
Hello all,
Hope I could find help about my question.
I have a worksheet with 8 rows each row contains a name of employee
and its timesheet during the next two years.
I separated the cells based on weekly days-off or days-on of the
employee and colored therefore.
The whole employees are working rotation 4/2 (4 weeks On, 2 weeks
Off).
My request is to create a sheet in the same workbook that I can see
through it the summary of two groups as follows:
1- Group 1 : category of employees on days-Off .
2- Group 2 : category of employees on days-On .
I want this will affectionate according to the today date.
It means one employee has two probabilities: On / Off
Sorry if I could not has the good English to explain what I am looking
for but the link below has the file I want to update; for further of
your references:
http://www.sendspace.com/file/g2f74m
Hope I will hear some suggestions.
Regards
Lassaad
Hope I could find help about my question.
I have a worksheet with 8 rows each row contains a name of employee
and its timesheet during the next two years.
I separated the cells based on weekly days-off or days-on of the
employee and colored therefore.
The whole employees are working rotation 4/2 (4 weeks On, 2 weeks
Off).
My request is to create a sheet in the same workbook that I can see
through it the summary of two groups as follows:
1- Group 1 : category of employees on days-Off .
2- Group 2 : category of employees on days-On .
I want this will affectionate according to the today date.
It means one employee has two probabilities: On / Off
Sorry if I could not has the good English to explain what I am looking
for but the link below has the file I want to update; for further of
your references:
http://www.sendspace.com/file/g2f74m
Hope I will hear some suggestions.
Regards
Lassaad