How to update Stock Book in Excel

satya (Executive Excise) (1839 Points)

22 December 2010  

Dear All Excel Experts,

 

We are maintaing Stock Book in Excel manually, but we need to copy stock values automatically (so that the stock will update in stock book - at present we are doing manually )when it is issued to party (Already format maintain in excel for issuing Item manually).

Kindly suggest  any formula or pre-difined sheet.

Thanks in advance.