Sensitivity Analysis
Ken Wright wrote:
Forget the macro.
With your data in cell A1, in any other blank cell, put
=$A$1
Now copy that cell, select your Forecast range and do Edit / Paste
Special / Multiply. They will all now contain a reference that looks
like *($A$1). Varying the value in A1 will trundle on through to
every cell in your range.
Ken
nice one :-)
|