# Work Allocation Across Dates

#### Enginair

##### New Member
Hello,

I've got a task given to me that's been quite manual in the past that I'm trying to speed up with the help of some vba/formulas.

Basically I've got a list of products (A,B,C) with a manufacture due date that need to be allocated between 3 different people (X,Y,Z).
The dates will differ every month but they are fixed.

Product A can only be made by Person X or Y
Product B can only be made by Person Y
Product C can only be made by Person Z

Person X must manufacture exactly 6 of product A in April, exactly 7 in May, exactly 6 in June and so on throughout the year..
There will always be at enough of product A in any given month that can be allocated to Person X.

An example of what the raw data would look like before work is allocated:

 Type Date Person C 1/4 A 2/4 C 2/4 A 6/4 A 8/4 B 10/4 A 12/4 B 15/4 A 16/4 A 16/4 A 17/4 B 21/4 A 25/4 C 28/4 a

<tbody>
</tbody>

Additionally as much as possible the work for Person X must be spread out over the month. For example using the table above instead of allocating 3x Product A over 16/4, 16/4 and 17/4 to Person X they would be allocated 16/4, 17/4 and 25/4. It doesn't matter how the work is allocated for Persons Y and Z.

An Example of what the finished data would look like:

 Type Date Person C 1/4 Z A 2/4 X C 2/4 Z A 6/4 X A 8/4 X B 10/4 Y A 12/4 X B 15/4 Y A 16/4 Y A 16/4 X A 17/4 X B 21/4 Y A 25/4 X C 28/4 Z

<tbody>
</tbody>

I hope I've explained it well enough.. I'm really not sure how to begin on this one, do you have any ideas how I could do this? My Googling/searching of this forum hasn't lead me to anything yet.

Any advice and help would be greatly appreciated!

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Replies
2
Views
90
Replies
6
Views
312
Replies
5
Views
78
Replies
8
Views
240
Replies
1
Views
143

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,714
Messages
5,833,279
Members
430,201
Latest member
Deepakpilla36

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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.
Go back