Please Help
 

Hi All,

My stock of products are in four stores, for each store either I am over
stock or I am having a lower stock than the needed qty. I need a formula that
can transfer the products from the stores were I am over stock to the stores
that needs this stock. Can any one help with this.

Example of the isuue,

P.ref store 1 store 2 store 3
store 4

over missing over missing over missing
over missing


p.ex 4 6 9
7

P.yx
10 12 20
5
P.xx 3 5
2 4

Thanks in advanced.

Please Help
 

Looks like a straightforward problem for excel solver. You will need to
ensure that it is included in your addins

firroo wrote:
Hi All,

My stock of products are in four stores, for each store either I am over
stock or I am having a lower stock than the needed qty. I need a formula that
can transfer the products from the stores were I am over stock to the stores
that needs this stock. Can any one help with this.

Example of the isuue,

P.ref store 1 store 2 store 3
store 4

over missing over missing over missing
over missing


p.ex 4 6 9
7

P.yx
10 12 20
5
P.xx 3 5
2 4

Thanks in advanced.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200808/1

Please Help
 

Thank you for your answer, however I didn't understand it can you please
clarify more.

Thanks

"edvwvw via OfficeKB.com" wrote:

Looks like a straightforward problem for excel solver. You will need to
ensure that it is included in your addins

firroo wrote:
Hi All,

My stock of products are in four stores, for each store either I am over
stock or I am having a lower stock than the needed qty. I need a formula that
can transfer the products from the stores were I am over stock to the stores
that needs this stock. Can any one help with this.

Example of the isuue,

P.ref store 1 store 2 store 3
store 4

over missing over missing over missing
over missing


p.ex 4 6 9
7

P.yx
10 12 20
5
P.xx 3 5
2 4

Thanks in advanced.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200808/1

Please Help
 

No Solver needed:
http://www.savefile.com/files/1731961

Please Help
 

"Herbert Seidenberg" wrote:

No Solver needed:
http://www.savefile.com/files/1731961
Thank you so much