Populate Schedule from Sun-Sat based on a given sched

[dlealb]

Hi All,

We are seeking help on how to Populate Schedule from Sun-Sat based on a given schedule provided

Cell A2 = Employe
Cell B2 = New Sched (Ex: Sun-Thu)
Cell C2 = New Shift (15:00-00:00)
Cell I2 & J2 = OFF

Goal:
Pupulate Cells D2-J2 based on the criteria provided above

[xladept]

Would you just have the nine hours scheduled randomly?

[dlealb]

Hi xladept,

Sadly no,
In our country an employee is only allowed to work 9 hours which includes 1 hour Lunch break
The sample provided is from 3:00 - 12:00 that's 9 hours

btw thank you so much for looking into it
we appreciate the assistance

[xladept]

OK - fixed that but do you want random nine hour shifts. I'm asking how you want the hours scheduled.

[dlealb]

Hi xladept,

The nine hour shifts are provided by our operation counterparts, We wanted to have this automated as there is over 4000 employee's who have their schedule's adjusted because of the pandemic situation as they transition to work from home.
So ultimately we wanted to reduce the hours of entering their new schedule's manually.

In the attached file the employee column would reach beyond 4000 and on the 3rd column is their new Shift which is provided by their site director as agreed with the clients to cover staffing gaps

[xladept]

Can you post some version of the input?

[dlealb]

Hi xladept,

Highlighted in Yellow would be our Goal.

[xladept]

But, where is the input - what is the input file name? These details are necessary to effect a routine

[dlealb]

We have attached a sample file hope its clear

[xladept]

Well, I finally understand - sorry for the confusion

I've coded a Select Case, thinking that you may add more schedules.

Try this:

Please Login or Register  to view this content.