Thread: Please Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
firroo firroo is offline
external usenet poster
 
Posts: 15
Default 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.