is it possible to create random numbers for 7 columns, where each column has a different min and max, but each row's 7 fields will add up to hundred.

By definition all the numbers cannot be random as at least one must "correct" the total down or up to 100!