rotating

Hello. I am new to the forum. I have spent about a week looking for answers and trying to solve this issue on my own. I am fairly well-versed with Excel... more so than a "general user"; however, I have little experience with coding and VBA. I have attached a mini-sheet of my list; it's pretty...

Good afternoon! I am trying to create a rotating work schedule. There are five main colleagues and six jobs. I want to be able to assign these jobs on a daily basis evenly. So every day, someone gets a different job when I click a button perhaps. Is that possible? For the sixth job, I want it...

I receive a report which details the time a truckload of material was dumped as a timestamp. I am wanting to write a formula which interrogates the timestamp and can then identify which work crew was on shift at the time the load was dumped. Shift details are as follows: 4 crews: A, B, C, D...

I receive a report which details the time a truckload of material was dumped as a timestamp. I am wanting to write a formula which interrogates the timestamp and can then identify which work crew was on shift at the time the load was dumped. Shift details are as follows: 4 crews: A, B, C, D...

Looking to create a file in excel that will help me find a rotating schedule for the following: 1. Saturday and Sunday Work Days 2. 3 Shifts (3 Doctors) on Saturday and 2 Shifts (2 Doctors) Sunday. 3. Doctors cannot work both days. (If you work Saturday you are off Sunday and vice versa) 4...

<tbody> A B C Week 1 Week 2 MFG A MFG B MFG C MFG A MFG B MFG C MFG A MFG B MFG C Bananas .6 .2 .2 ON Apples .1 .4 .5 ON Oranges .3 .5 .2 ON </tbody> Columns A,B and C represent Percentage of Unit Volume by MFG for the Fruits to the left. Using...

As you see below I have a list of dates that rotates ever week, the numbers in the right column are supposed to rotate with them. I'm pretty stuck, not sure how to even start this. the formulas I used are in the second list Date # 19 Dec 14 1 26 Dec 14 2 02 Jan 15 1 09 Jan...

Hi all, This is my first post to this forum. Hope i get some valuable replies here. :) I am trying to create a simple BiWeekly roster (extendable to Monthly) for my workflow support team using either VBA or worksheet functions though i am not able to proceed further than the design...