Solver

[Chaddy]

Found is the file enclosed. Sorry for any inconvienence.

[shg]

Welcome to the forum, Chaddy.

If you want help with Excel, please post workbooks and not pictures.

[Chaddy]

Sorry to sound stupid but how do I get a workbook?

[shg]

Forum rules are a great resource:

If you want help with Excel, post an Excel file, not a picture, Word file, PDF, or text file. Nobody's anxious to type data from a picture into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and the push the Upload button.

[Chaddy]

There's the file

[shg]

The target cell and the changing cell can't be the same.

The target cell has to have a formula, and the changing cells cannot.