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