Populate data according to specific numbers

Hello
I have the range("C1:C30") This is the range where I want to populate my data

The numbers which I will distribute the data according is in C33:C37
Say for example (5 - 6 - 4 - 10 - 3)

The total of these number are 28 so the first two cells C1 and C2 will be empty
From C3:C7 should be filled with "A"
From C8:C13 should be filled with "B"
From C14:C17 should be filled with "C"
From C18:C27 should be filled with "D"
From C28:C30 should be filled with "E"

Note that the numbers are variables not constants

I have solved this part by this code

Please Login or Register  to view this content.

Now I want to extend the range to be C33:G37 and to apply the previous code to the columns ("C:G")


Here's the file

thank you very much for your reply
your code works fine except one thing
If the total in rows 33:37 less than 30 then the difference should be empty cells
this happened for your code for column C only but not for other columns

I have found the solution Mr. Jazzer
Here's my working code

Please Login or Register  to view this content.

Thanks for offering great help

عفوا

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved:

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."