excel vba

  • Thread starter Thread starter bforster1
  • Start date Start date
B

bforster1

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

simple yet complex scenario - goal seek problem 1
Excel 2007 VBA - looping through scenarios not possible? 1
Trouble with ActiveX Control - Combo Box 4
How to refresh an Excel workbook from VBA 2
Using VBA to copy a Chartsheet to Powerpoint 2
How to make a VBA Function return a value in percent format 8
Adding CAGR line to Column Chart 0
How do I quickly export 90 diff versions of 1 .xls chart in ppt? 1

Back
Top