excel - Generate matrix values based on fixed column and row sum using VBA

Question

I am currently handling a problem that requires me to generate a matrix containing only values between 0,1 and 2, such that sum of the column and row matches the one that is given.

Example:

Image of the problem

What I want to get is the values inside the table, such that the sum matches colsum and rowsum. Is there a way we can get it done using VBA?

question from:https://stackoverflow.com/questions/65896115/generate-matrix-values-based-on-fixed-column-and-row-sum-using-vba

Answer 1

Waitting for answers