Hi,
for a case-study in my university I need to create an excel-file. But I have
some problems with a variable which should be dynamic.

Below you can find a link to an example with further descriptions. I need to
calculate the target stock in Sheet 2 via a VBA code because target stock is
dynamic and dependant on shortage, capacity and stocks.

Hope you can help me

http://www.2shared.com/file/9489655/...get_stock.html

What specifically are you having issues with. I typically don't download
files from this site, but if there are questions you have, we may be able to
help.
--
HTH,

Barb Reinhardt



"maywood" wrote:

Hi,
for a case-study in my university I need to create an excel-file. But I have
some problems with a variable which should be dynamic.

Below you can find a link to an example with further descriptions. I need to
calculate the target stock in Sheet 2 via a VBA code because target stock is
dynamic and dependant on shortage, capacity and stocks.

Hope you can help me

http://www.2shared.com/file/9489655/...get_stock.html

Excel 2007
With Solver
http://c0444202.cdn.cloudfiles.racks.../11_27_09.xlsx

Hi Herbert,

the Solver is a possibility to solve my problem if the shortage is static or
in one month like in my example.

But in my more detailed Excel Sheet here at home, I am importing new data
each month. And then I do a little Scenario where I vary the demand. From
this it follows that the shortage can exist in no month, in one month or in
up to 12 months.
Can I use the solver to optmize 12 cells at a time?

"Herbert Seidenberg" wrote:

Excel 2007
With Solver
http://c0444202.cdn.cloudfiles.racks.../11_27_09.xlsx

.