Solver for multiple input changeable cell ?

[kcsaba]

hello I am trying to create an automated solution table with solver.

column

R1C1 input dollar value - changeable
A%*R1C1 /0-100/-changeble
B% (100-A%)*R1C1
sum A
sum B
if
if
....
C15 Result a+b-if s

Goal : Create a table for numbers 0 in 500 steps to 100 000 with lowest Result for optimal A%.

Is it possible without any macro /I use this in loop/ ?

ActiveCell.FormulaR1C1 = "1000"
Range("C15").Select
SolverOk SetCell:="$C$3", MaxMinVal:=2, ValueOf:=0, ByChange:="$C$3", Engine:=1 _
, EngineDesc:="GRG Nonlinear"