How to update Stock Book in Excel

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