 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008SCENARIO ON MULTIPLE SHEETS
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. 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 On Feb 5, 2:28 pm, kellonja...@gmail.com wrote: > Hello All, > I have a work book with 25 work sheets. Sheet 1 contains the rate for [quoted text clipped - 3 lines] > line). If I use the regular format I will exceed the number of > variable cells. How do I create this SCENARIO. 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. > Hello All, > I have a work book with 25 work sheets. Sheet 1 contains the rate for [quoted text clipped - 3 lines] > line). If I use the regular format I will exceed the number of > variable cells. How do I create this SCENARIO. 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. > 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. [quoted text clipped - 6 lines] > > line). If I use the regular format I will exceed the number of > > variable cells. How do I create this SCENARIO. Please lookup "scenario" in Excel Help, much assistance and examples there. > 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 [quoted text clipped - 11 lines] >>>line). If I use the regular format I will exceed the number of >>>variable cells. How do I create this SCENARIO. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.