View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
hamed hamed is offline
external usenet poster
 
Posts: 7
Default updating data entry

hi challa,
thanx for the reply.as you may know the process of inventory is additive;in
other words all the receiving are added sequentially.for example if the
availability of partB in inventory is now 100 and we've had two receivings of
5 and 100 the availability now should be 100+5+100=205.in your procedure ahe
very last receiving will be added to inventory,the result would be
200(100+100)!