SCENARIO ON MULTIPLE SHEETS

[kellonjames]

Hello All,
I have a work book with 25 work sheets. Sheet 1 contains the rate for
my formulas. Sheet 2 ( the working sheet) uses the formula from sheet
one to cost my products. In some instances there are more that 40
products that use the same rate formula. (each product requires a
line). If I use the regular format I will exceed the number of
variable cells. How do I create this SCENARIO.

 

[Pete_UK]

Could you give an example of what you do now? You can use VLOOKUP to
get the rate from Sheet1 for your products, so I'm not sure what your
problem is.

Pete

 

[Bob I]

Your question doesn't make a lot of sense. Even before Excel 2007 you
have 65 thousand rows and 256 columns of cells to work with.

 

[kellonjames]

I would like to evaluate the total cost is a few rates were to change.
If I ues the Scenario Function (what-if analysis) i will be able to
create a comparison table to see the effects of the rate change on the
Total.

 

[Bob I]

Please lookup "scenario" in Excel Help, much assistance and examples there.