Complicated but... here's the final product I need:
Bold = data I have
non-bold = data how I need it to show
<tbody>
</tbody>
Customer A gets the data from column #2(B) up to 20 (10+10)
then because Customer A is done w/ 20, it goes to Customer B
Customer B gets the data from column #2(B) up to 120 (80+10+10+10+10)
A bit complicated to explain but I hope you get it. I'll happily answer any questions. I'm OK w/ VBA. Thank you!!!
Bold = data I have
non-bold = data how I need it to show
Customer A | Customer B | ||
20 | 120 | ||
Product 1 | 10 | 10 | |
Product 2 | 10 | 10 | |
Product 3 | 80 | 80 | |
Product 4 | 10 | 10 | |
Product 5 | 10 | 10 | |
Product 6 | 10 | 10 | |
Product 7 | 10 | 10 |
<tbody>
</tbody>
Customer A gets the data from column #2(B) up to 20 (10+10)
then because Customer A is done w/ 20, it goes to Customer B
Customer B gets the data from column #2(B) up to 120 (80+10+10+10+10)
A bit complicated to explain but I hope you get it. I'll happily answer any questions. I'm OK w/ VBA. Thank you!!!