condensing long if's based on same numbers (loop)

Code first:

Please Login or Register  to view this content.

As you can see this is a repetitive if formula.

It is based off of combo boxes names cmbS1T1-cmbS10T2
Then for each there is cmbPpl1-14

The usage is the start time and end time of each shift. (S = shift) (T = 1 for start, 2 for end)

The cmbPpl are how many people will be at each shift 1-14


If you look at the above code you will see the cells it is going into. Same repetitions as above.


The only difference is that if there are less than 6, it should use the entire box and if more than 6 it will split the 4 cells wide box in half and use the first half for shift 1 and the second shift would be in the smaller box to the right it just split to.

Examples are included in the attached excel document.

Any questions please ask.

I am just looking for a condensed loop formula of some sort that would do this before I spend 4 hours writing it all out. I am sure there is a better way.

Thanks.

Hate to be a bother but I don't use any other forums for excel. Is there no way to loop this or could anyone start me out on it. I'm newer to the loops in excel so I'm not sure I can figure it out.

If it's not explained well enough let me know.

If you could even explain how you would loop it I'm sure I could figure it out. Thanks.