Cell Names in Scenario Summaries

  • Thread starter Thread starter Bufo Calvin
  • Start date Start date
B

Bufo Calvin

Does anyone know a way to get a Scenario Summary to
automatically show Names for cells (assuming they exist)
rather than the cell references?

For example, a Scenario Summary will show:

$A$1 500
$B$1 1000

when those cells might be named "Dogs" and "Cats".

I can always copy and paste afterwards, but that's not
very elegant.

TIA
 
The Scenario Summary should automatically use the cell names, instead of
the cell references.

Check the Names List (Insert>Name>Define to see if the names exist.
 
Thanks!

That wasn't the problem, but it pointed me to the
answer. I was incorrectly expecting it to list the key
values (the leftmost column), not the changing cells.
 

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

"Poor Man's" Scenarios 5
Worksheet Names is Defined by Cell value on Sheet 1 (named Summary 7
Scenarios 2
how to return "summary" of all non-blank cells plus their headers 10
Linking different cells from one sheet to another in same workbook 2
modify all formula references in multiple cells 3
data to summary sheet for a dummy 0
how do you name the changing cells in a scenario? 1

Back
Top