HI Respected members ,
I am looking for your support to find a solution for my simple inventory system.
I have my data base in a sheet named stock where I have my stock listed with the stock code with the current stock
stock.JPG
I do the selling with simple page to record with vlookup function using the Item code from the stock table ..
As I do the sales, I need to reduce the actual stock on the stock sheet ..
sales 2.JPG
Is this possible ?
(I use a barcode reader to read my item codes .)
*Hope you guys can help me ---
Bookmarks