My name is Imran, I am working in one of Restaurant and my boss has recently asked to prepare the file of consumption which has automatically link with receipes file and it has following features as well;-
Stock inventory of each item
Closing inventory facitlities
When we put the sold amount it automatically show the standard consumption of each items
I also attached file of closing inventory of Fifo xls format the main problem of that file is if I put the different item with different epiry in respective coloum and when I depatche the different item, it doesnot working.. I need that when I put the dispatched quantity. Firstly it show the ending inventory in expiry and match and setoff automatically
CAN YOU HELP ME OUT AT THIS CRITICAL SITUATION OF UNEMPLOYMENT PREVAIL ALL OVER THE WORLD. I HAVE LEARNED ABOUT YOUR WEBSITE IN EXCEL FORUM.

Thanks & Regards

IMRAN

First, can you upload sheets that have a BEFORE/AFTER approach so we can see what is supposed to happen when you add/enter additions/depletions.

Second, it appears you are already using VBA on this sheet, but the VBA was not included in the sample. Please leave the macros in so we can see the sheet in its operational form.

Third, this kind of thing is very difficult to achieve with worksheet formulas, but probably not so hard with VBA. Have you looked at using VBA to handle the "depletions"?

I might suggest that a spreadsheet is not the best platform for this type of application. I would be more inclined to use Access. There are Inventory management templates for Access that you can use as a starting point.

Quote:

---

Originally Posted by ScottGem

I might suggest that a spreadsheet is not the best platform for this type of application. I would be more inclined to use Access. There are Inventory management templates for Access that you can use as a starting point.

---

I absolutely agree.