Goal seek to get the same value in certain cell

Hi excel experts
in cell a1 there is a value 34156 and I put some formulas to distribute the value to certain values 200,100,50,20,10,5,1
How to generate random numbers in column d but with a criteria to get the same value 34156 in last cell in column e in cell E11?