VBA: Random generate numbers

[Rulenine]

Hi all!

I am making an accounting spreadsheet that auto generates practice problems for students that I tutor. I have most everything done, but I need a way to generate the actual numbers (randomly each time) for each account, but still have my assets equal to my liabilities/equity.

So basically what I am looking for is a way to randomly generate a two arrays of numbers while ensuring that they both end up equaling the same number. Any ideas?

 

[RedBeard]

Like this maybe? Generate N random numbers whose sum is a constant K - Excel - Stack Overflow