ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What if scenarios using multiple worksheets (https://www.excelbanter.com/excel-worksheet-functions/264402-what-if-scenarios-using-multiple-worksheets.html)

Catalin[_2_]

What if scenarios using multiple worksheets
 
Dear Friends

Is it possible to have scenarios in XL 2003 across 2 or more worksheets?
Which means, for example, I had some chaging cells in one sheet other cells
in another worksheet and the result in the first one.

I have tried lately but I got an error message. The same problem I have
encountered with the Solver.

How could I overcome this issue?

Thanks in advance,
Catalin

Don Guillett[_2_]

What if scenarios using multiple worksheets
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Catalin" wrote in message
...
Dear Friends

Is it possible to have scenarios in XL 2003 across 2 or more worksheets?
Which means, for example, I had some chaging cells in one sheet other
cells
in another worksheet and the result in the first one.

I have tried lately but I got an error message. The same problem I have
encountered with the Solver.

How could I overcome this issue?

Thanks in advance,
Catalin




All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com