I think I need VB???

[Calgarycarrie]

I have three sales models in the same spreadsheet. I set up a dropdown menu that uses different input values based on whether I select “upside”, “base” or “downside” from a dropdown. I have an output sheet where I want to see my resultant peak value for each of my models (upside, base, downside). Is there a way to this without manually selecting
“upside” in my dropdown, copy/pasting my resultant peak value in my output sheet, then selecting “base” in my dropdown, copy/pasting my resultant peak value in the next cell in my output sheet, and finally selecting “downside” in my dropdown, copy/pasting my resultant peak value in a third cell in my output sheet?

 

[Micron]

One code procedure should be able to do whatever it is that calculates the 1st peak value then pastes the result somewhere, then repeats for the other 2 inputs, pasting below the last entry. So as per your thread title, I don't see how anything other than vba could do that, but I never say never.