How to split a number in different cells, excel macro

[bigmon]

Greetings everyone. I'm trying to work on a macro that would take the total number (the highlighted numbers) per each column and split it randomly in the cells of the same column, till the end, so for every country it will have a random number. All the random numbers for each country have to sum up to the total number.
Pageviews nr > Impressions nr > Clicks nr

C > D > E

The numbers in column C has to be bigger than D The numbers in column D has to be bigger than E
Anyone has any ideas?

 

[shrivallabha]

Cross-posted : https://stackoverflow.com/questions/62910974/how-to-split-a-number-in-different-cells-excel-macro

In case of cross-posting just make sure that you inform about it. Since you are a new user will recommend you to go through forum rules.
https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/