Thread: Scenarios
View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

There's a sample workbook here, that uses an alternative method to show
scenarios:

http://www.contextures.com/excelfiles.html#Scenarios

under the heading, 'Alternative to Scenario'

Variables are stored on a worksheet, and a scenario name is selected
from a dropdown list to display its variables.


JosefS wrote:
I have an assumptions sheet for a financial model that has more than 23
cells. How can I save different versions without saving the worksheet using
SaveAs



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html