What if Formula Without Changing Main Data

[Bkisley]

Hey everyone - I got a tricky one for you today!

I have a set of data that is summarized on a separate tab. The outputs on this tab CAN NOT change
On this separate tab I also have 3 cells that I need to run a "What if" scenario on

This equation would tell me the impact of a metric/output if a certain cell were to change. Once again, this can not change the original output tab.

To make this clearer
Tab1 is all of my data / financial model
Tab 2 is my financial summary where I pull important items such as sell price, cost, etc.
On my second tab, I have a section that needs to show how my outputs would change if my sell price decreased by 1%

Let's say my sell price is on tab 1 cell G69
On tab 2 in cell E24 I need to show the impact to Tab 1 cell P56 if I change my sell price on Tab 1 cell G69 to 1% less

I can't change cell G69 because that will impact my entire output summary
I can't change the cell manually and copy and paste values because we may change the sell price multiple times or forget to redo this everytime

Is there a way to do this??

Thank you!!

 

[sgroath]

Is it possible to copy tab 1 to a new tab and then leave all of your formulas but refer values back to those on tab 1? If so, you could have G69 on the new/copied tab refer to your changed value and you could show your differences on tab 2 based on the updated data in this new/copied tab. Brute force but if viable, simple can be best.