Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Tony0z
 
Posts: n/a
Default Scenario Manager

New to using Scenario Manager. I have a worksheet set up that I now must
outline 7 scenarios. Whilst i am able to do each scenario it is possible to
have one scenario summary worksheet showing all 7scenarios or must i have 7
sceanrio worksheets?

If I can have one scenario worksheet how do I go about this?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Debra Dalgleish
 
Posts: n/a
Default Scenario Manager

If the Scenarios are on the same worksheet, you show them in one
summary, as described he

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

Tony0z wrote:
New to using Scenario Manager. I have a worksheet set up that I now must
outline 7 scenarios. Whilst i am able to do each scenario it is possible to
have one scenario summary worksheet showing all 7scenarios or must i have 7
sceanrio worksheets?

If I can have one scenario worksheet how do I go about this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scenario manager and IRR PeterW Excel Worksheet Functions 0 February 15th 06 02:04 AM
Creating Scenarios and Scenario Manager Louise Excel Worksheet Functions 4 February 15th 06 01:17 AM
why report manager ignores the range set in the scenario Annm Excel Discussion (Misc queries) 0 September 28th 05 06:43 PM
Sumif Linking to Another Workbook error #VALUE! Tunde Excel Discussion (Misc queries) 16 March 4th 05 03:02 AM
Excel Scenario Manager should let me re-order scenarios (in the s. Jayson Beatty Excel Discussion (Misc queries) 0 December 2nd 04 08:25 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"