YasserKhalil
Well-known Member
- Joined
- Jun 24, 2010
- Messages
- 852
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 hope that is clear
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 hope that is clear