Hi,

I am trying to randomly generate data for a spreadsheet that I'm working on.

Basically I've got a grid with the cell reference a1:c10. I want to randomly generate data for that grid and I want that data to adhere to the following constraints.

The total of each row has to equal 10. Column A's total should be 150. Column B should be 100 and Column C 50.

Can anyone help?

Cheers

-Alan