Hello everyone,
Come back to my favorite topic
Have a small VBA script built in that he automatically shows the entered working hours on the sheet "Januar" in the sheet "IND1" in the respective employee row.
For example, if I enter the time in Dienst 1" for "MA1" in sheet "Januar" from 12:00 to 15:00, all cells between 12:00 and 15:00 (include them too),
should appear in color on sheet "IND1" from 12:00 to 15:00 . the rest no color.
The same should happen for every "Dienst 1, 2 " and “Bereitschaft” in every "MA" (all 10 MA & GL) in sheet "IND1".
Notice: if MA have 3 diferent times Dienst in the same Day, must be only the time line in the Workingtime appear.
“MA1” haves “Dienst1”: “von 12:00 ‘”bis 15:00”, “Dienst 2” “von 16:00” “bis 19:00” and “Bereitschaft” “von 20:00” “bis 5:30” all working times write in sheer “Januar”,
must appear all this workingtimes in colour, rest cells no colour in the same row in sheet “IND1”
Workbook Link: VBA Timeline ala Gant VBA script
This VBA script is hanging somewhere. Has been made by a good person to help me, only for the next time he is prevented for personal reasons.
Any help is welcome ... need "a little" support.
PS. The VBA code should be so that I can copy it in the new sheets for each month.
Big Thanks in advance ?
Come back to my favorite topic
Have a small VBA script built in that he automatically shows the entered working hours on the sheet "Januar" in the sheet "IND1" in the respective employee row.
For example, if I enter the time in Dienst 1" for "MA1" in sheet "Januar" from 12:00 to 15:00, all cells between 12:00 and 15:00 (include them too),
should appear in color on sheet "IND1" from 12:00 to 15:00 . the rest no color.
The same should happen for every "Dienst 1, 2 " and “Bereitschaft” in every "MA" (all 10 MA & GL) in sheet "IND1".
Notice: if MA have 3 diferent times Dienst in the same Day, must be only the time line in the Workingtime appear.
“MA1” haves “Dienst1”: “von 12:00 ‘”bis 15:00”, “Dienst 2” “von 16:00” “bis 19:00” and “Bereitschaft” “von 20:00” “bis 5:30” all working times write in sheer “Januar”,
must appear all this workingtimes in colour, rest cells no colour in the same row in sheet “IND1”
Workbook Link: VBA Timeline ala Gant VBA script
This VBA script is hanging somewhere. Has been made by a good person to help me, only for the next time he is prevented for personal reasons.
Any help is welcome ... need "a little" support.
PS. The VBA code should be so that I can copy it in the new sheets for each month.
Big Thanks in advance ?
