Quantity automatic update if total amount(Constraint)

[aligahk06]

Dear All,

I have a problem and try to solve .I am desperately hitting for solution.
Col B and ColI is fixed.
my Total amount in Cell j206 is fixed constraint.
Let it be 80000.00
I want to play only with quantity in colG in such a way that after multiplying each value in ColG with corresponding
value in Cell I then total Amount in j.
After Summing j2:j205 the total should be 80000.(fixed)

For Example if i put 90000.00 in cell J206 then quantity automatic adjusted in Col G.(Range G2:G205).
Moreover, The Quantity in Remove cLADDING, rEMOVE INSULATION, INSTALL INSULATION,INSTALL CLADDING must be same.

Any Solver or technique in this regard is deeply welcome.


Rgds,

Aligahk06