satya (Executive Excise) (1839 Points)
22 December 2010Dear 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.
CA CS CIMA Prakash Somani
(Landmark Group)
(23502 Points)
Replied 22 December 2010
there is very simple way to do so... i.e. import the particuler webpage in excel and it will automatic update .
Even you can set timer in which it refresh itself automatically without any manual intervantion.
refer attached excel
Exshail
(Software)
(1576 Points)
Replied 22 December 2010
if you are using fifo method, download fifo inventory excel workbook (without any vba codes) from below site.
https://shahshaileshs.web.officelive.com/Misc.aspx
shailesh
CAclubindia
