Dynamic What if Analysis

Is there a way to create a Dynamic what If analysis instead of the static table/new sheet output?

Thanks

I don't think I am looking for a data table, I have two columns that are independent with multiple (14) variables that will change a standard deviation value. I can do it using what if and it will give me the static output page, I am wondering if I can have a similar outcome but have the "What if Scenarios" in columns adjacent to to the master one. Hope that explains what I am looking to accomplish.

Thanks

Sorry for the delay, I created a new work book to upload. It's a bit messy but I think it will achieve the goal. You will see orange highlighted cells, what I am trying to do is a sort of what if analysis on cells U37 & U38 if the cells in U29:U31 equal the value in V29:V31, W29:W31, and so on. I can do this as what if analysis but if I change any of the variable values U29:U31 and S29:S31 I would need to redo the what if each time. Looking for a way to make it display in the orange area. I can do it one at a time but I would like to have a side by side comparison to analyse the impact of changes.

Thanks



Book2.xlsx