(1) Suppose cell C1 is a complicated formula (objective function)
which depends on B1 (a parameter) and A1 (a variable)

(2) For every value of B1 suppose there is an A1 which maximizes C1.
Is there a way that whenever I change B1, the value of A1
automatically changes so that C1 is maximized.

I know how to find any new A1 corresponding to a new B1 by using
solver. But I have to go and do this manually.

I really appreciate any help.