Data Validation

levy77

New Member
Joined
May 7, 2019
Messages
47
Hi

I have a financial model which includes a whole heap of scenario analysis. To change the scenario for each cell you click the drop down and select best, base or worst. However, if you wan to run a worst case for everything you have to select each individual cell and select worst. Is there a a way to set all scenarios to Best, Base or Worst but then change one or two of the scenarios after?

Cheers
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
Not from the same data validation but, you could have one cell that controls Best, Base or Worse from where you would like to source your data and then choose the value per cell.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,919
Messages
5,447,280
Members
405,446
Latest member
morsecode

This Week's Hot Topics

Top