G
gbeaulieu
I have a problem that I've been trying to solve the last 2 days withou
results.
I need to add the period in which an employee will be working in a grap
( see Calendar Tab).
In the sheet 1, every employees will have a task assigned and a period
The task will be a drop down list (I only use 1,2 or 3 for now) and eac
task will have a different colour. Also, the period will be entere
manually (for month to month).
For every task and period entered, I need the fields in the shee
Calendar to be automatically filled giving the criteria. For example, i
employee xxx1 is assigned to task 1(let's say it's red) from May 2012 t
December 2012, in the Calendar tab, a red line should appea
automatically next to his name from May 2012 to December 2012.
Anyone as a solution for me?
Regards
+-------------------------------------------------------------------
|Filename: IT ORS Structure 2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=369
+-------------------------------------------------------------------
results.
I need to add the period in which an employee will be working in a grap
( see Calendar Tab).
In the sheet 1, every employees will have a task assigned and a period
The task will be a drop down list (I only use 1,2 or 3 for now) and eac
task will have a different colour. Also, the period will be entere
manually (for month to month).
For every task and period entered, I need the fields in the shee
Calendar to be automatically filled giving the criteria. For example, i
employee xxx1 is assigned to task 1(let's say it's red) from May 2012 t
December 2012, in the Calendar tab, a red line should appea
automatically next to his name from May 2012 to December 2012.
Anyone as a solution for me?
Regards
+-------------------------------------------------------------------
|Filename: IT ORS Structure 2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=369
+-------------------------------------------------------------------