I want to create the scenarios in scenario manager, but do it
automatically with a macro rather than entering them one by one.
Especially in cases where I have 15-20.

For example,

hypothetically let's say the cells to change are A1 and B1 and result
cell is C1.

I would like to put data in A2:A7 for one variable and B2:B7 for the
second variable.

let's say the result sell is simply the sum of A1 and B1.

So basically, can I use a macro to take the data in A2:A7 and B2:B7 and
create the six scenarios

thanks


--
SterlingA
------------------------------------------------------------------------
SterlingA's Profile: http://www.excelforum.com/member.php...o&userid=10913
View this thread: http://www.excelforum.com/showthread...hreadid=382252