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.
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
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
