excel vba
 

I am developing a financial projection model and would like to ru
different scenarios and chart the results. Is is possible to hav
certain variables put in cells..ie revenue growth ... and then hol
them constant as I run another scenario to allow me to chart both set
of numbers.

I would run one scenario and the % of revenue growth would b
calculated and the results referenced to certain cells. However, whe
I run another scenario I don't want the results of the first scenari
to change.

Any suggestions?

--
bforster
-----------------------------------------------------------------------
bforster1's Profile: http://www.excelforum.com/member.php...fo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=26641

excel vba
 

Why not just 2 ??

--
Don Guillett
SalesAid Software

"bforster1" wrote in message
...

I am developing a financial projection model and would like to run
different scenarios and chart the results. Is is possible to have
certain variables put in cells..ie revenue growth ... and then hold
them constant as I run another scenario to allow me to chart both sets
of numbers.

I would run one scenario and the % of revenue growth would be
calculated and the results referenced to certain cells. However, when
I run another scenario I don't want the results of the first scenario
to change.

Any suggestions??


--
bforster1
------------------------------------------------------------------------
bforster1's Profile:
http://www.excelforum.com/member.php...o&userid=11771
View this thread: http://www.excelforum.com/showthread...hreadid=266416

excel vba
 

If the % of revenue growth is calculated, then you will need to write the
results as a hard coded value to another cell. You could write code to do
this and trigger it with a commandbutton.

--
Regards,
Tom Ogilvy

"bforster1" wrote in message
...

I am developing a financial projection model and would like to run
different scenarios and chart the results. Is is possible to have
certain variables put in cells..ie revenue growth ... and then hold
them constant as I run another scenario to allow me to chart both sets
of numbers.

I would run one scenario and the % of revenue growth would be
calculated and the results referenced to certain cells. However, when
I run another scenario I don't want the results of the first scenario
to change.

Any suggestions??


--
bforster1
------------------------------------------------------------------------
bforster1's Profile:
http://www.excelforum.com/member.php...o&userid=11771
View this thread: http://www.excelforum.com/showthread...hreadid=266416