Seating Arrangement in Excel

Hi, I need to setup the seat allocation in excel, in the attached file I have details of the teams & number of advisors in every team to be seated. The data is in L1:P11 in the attached sheet. Now, I am trying to allocate the same number of seats in another area in the same sheet (B2:I2); This is a group of 4 sets of 2 rows containing 16 seats each. I tried this with the simple countif, and if formulas, on a reduction basis, based on the number of seats left to be allocated. This has also involved using Circular Reference. I dont have a problem with using Circular Reference, I also increased the number of iterations in calculations to 100 with Maximum change bieng 0.001. But the result for this is vague and isn't the one I desire. Although I could use Macros to distribute this, I am unable to use them due to some problems with the security at the office as it doesn't let macros run. Hence the solution will have to be formula based. Kindly help.

Thanks micope21 you have saved my day