Scenarios larger than 32 cells

[Chris S]

I am using Scenario Manager to interchange a group of
about 120 cells. Recognizing the Excel limitation of 32
cells per scenario, this forces me to identify 4 separate
scenarios for each group of data. Is there an alternate
solution which would reduce the number of scenarios I must
designate ? I have in the past used macros to copy/paste
the cell values into the proper position, as opposed to
scenarios. So is the macro/VBA solution more efficient ?

Your thoughts and help would be appreciated.

Regards,
Chris S.

 

[Debra Dalgleish]

There's a sample workbook here, that uses an alternative method to show
scenarios:

http://www.contextures.com/excelfiles.html#Scenarios

under the heading, 'Alternative to Scenario'

Variables are stored on a worksheet, and a scenario name is selected
from a dropdown list to display its variables.

It's easier to maintain than scenarios, and could be linked to a database.

 

[Chris S]

Debra ... thanks for the suggestion. I downloaded the
file but need an explanation as to how you generated the
dropdown box. I looked for a combo box and/or list box
elsewhere in the file, but could not find it.

Chris S.

 

[Debra Dalgleish]

It's a data validation dropdown list. There are instructions here:

http://www.contextures.com/xlDataVal01.html