Formula needed for showing result while value of any cell is changed in the model

I prepare complex financial models. In the models, sometimes I want to know the result (projected net profit) if any cell containing a formula or value is changed while keeping the original result intact (to be shown in another sets of cells, and this is not a data table problem). I want to know if there is a formula that can show the result (like data table) if certain inputs are changed.

In the sample file, I want answer in row 8 if (for an example) value in B11 (which is a formula) or B12 (which is a value) is changed. But I want to keep the original result intact in row 7.

I have posted in other websites too.
https://chandoo.org/forum/threads/fo...e-model.43295/
https://www.mrexcel.com/board/thread...model.1118657/

You'll need VBA to do what you want. You could set up a macro that will convert selected cell ranges to values, for example.

I am moving the thread to the VBA section.

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Thank you. No, I can't help you (not my specialism), but somebody will. Be patient, please - all the help you get here is for free.