Forum

Notifications
Clear all

Generate random numbers where sum is equal to a constant

2 Posts
2 Users
0 Reactions
135 Views
(@arbil)
Posts: 1
New Member
Topic starter
 

(1) I need to generate numbers into (ex) 5 columns. These generated numbers should be between the number specified in each column headings.

(2) The sum of the 5 randomly-generated numbers should be equal to a constant.

sample worksheet

Any input/why-is-vba-running-slowly will be greatly appreciated...

 
Posted : 18/12/2017 6:03 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Erick

See if this helps.

May I know what you need this for?

Sunny

 
Posted : 18/12/2017 8:55 pm
Share: