Solver or solver table help

I am trying to refine a financial model to solve for the exit multiple (which is also the key driver) based upon a set of various returns outcomes (which are dependent on the exit multiple). In order to do this, I need to use solver, which I have done and can do without issue on a one-off basis.

My problem is that I need to automate solver or create a function that will update the values in the table after various inputs in the model have been adjusted. I have tried to use a macro, but I can only get it to update one of the variables in the table. Not sure if a macro is the right way to go--I have also tried to use solver tables, but can't get these to work. See the attached for an abbreviated model.

No experience with VB or macros (or solver table add-in). Does anyone have any suggestions?

Thanks in advance for any assistance.

Hi,
Click on the button to fill the table.
Tony

You are the man!!

Thank you so much.

Hello,
I can't download the file, is it still online?
Ale

Yes I downloaded it just 10 minutes ago. Be aware that this is a xls file and since it contains a macro that runs solver you need to set a reference to the solver.xla file.

Alf