ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Naming the Result Cells on a Scenario Summary (https://www.excelbanter.com/excel-discussion-misc-queries/175037-naming-result-cells-scenario-summary.html)

dsttexas

Naming the Result Cells on a Scenario Summary
 
When I run a scenario summary, the Results section has labels that refer to
the cell(s). How do I have it display a meaningful text label in those cells?

Somehow I managed to do this some time ago when I first created the
spreadsheet and did a number of scenarios. Then I re-did some of the
formulas, and need to change the labels that refer to those results. I tried
various
Edit / Name actions on the the result cells themselves, but they still show
the original labels I somehow created some time ago. I can type over the
labels in the Scenario Summary sheet, but then have to do that again each
time I re-run the scenario.


All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com