Good day,
I am busy building an automated shift system whereby I will be able to generate my own shift system by only indicating the master shift pattern and then I want it for 6 employees with conditional formatting indicated by a separate column.
Thus, if the shift pattern is...
<tbody>
<colgroup><col span="2" style="text-align: right;"><col style="text-align: right;"><col style="text-align: right;"><col span="6" style="text-align: right;"></colgroup><tbody>
NAME
DAY
DAY PERIOD 1 NAME
DAY PERIOD 2 NAME
DAY PERIOD 3 NAME
DAY PERIOD 4 NAME
DAY PERIOD 5 NAME
DAY PERIOD 6...
Hi
I am trying to create an auto table in excel for a daily work schedule for my employees.
I would like to have the names of employees in colomn "J". addded to a table on the left automatically.
Each employee would start and end at different times given in columns "K" & "L",
and must have...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.