no that is not what i want, the amounts in column B starting from B6 to B12 have to be distributed in C7 till F12 based on the limits specified above and maximum sum of limits upto 4th layer can be 185,000,000 as shown in B6 and distribution. Basically i want the distribution done as distributed in yellow highlighted area. The Column H6 to H12 shows total distribution to be done in C7 till F12 considering the max limit for distribution 185,000,000.