Create scenarios using macro and data in cells
if you mean "adding a scenario in the list of excel scenarios" using a
macro for that:
start the recorder in the macro menu
create a scenario
stop the recording
go in VBA editor to see the syntax
re-use it as you wish
IF you mean "doing the same job than a scenario, whithout using a
scenario" then... just write a macro ! ;-)
For anilso... : a scenario is a pre-fetched data in cells so you can
change "initial data" on a sheet and then compare methods, prices, or
whatever... You change input data depending on a known "scenario"
|