Thread: Inventory

Hi guys,

Is there a way to set up a inventory that automatically adjusts as I enter in new data by searching the entire workbook?

What I want to do is set up an inventory page where I list all of the foods that I have in my refrigerator and the volume/quantity of what I have.

Then as the days go by and I add food to my daily consumption list I want those values on the inventory page to decrease by the amount entered.

Example.

Milk= total 20 Cups

2-2-12 1 cup milk (inventory now reads 19 cups milk)...

What I think could work would be a search function that would find all instances of Milk, then look 2 cells over to the "quantity" and then it would subtract it from the inventory cell. Maybe INDEX and MATCH can be used...

Is this possible?
I could really use the help.

Jonathan

Hi Jonathan,

You need to structure your workbook very well in order to achieve this... since you are using one sheet per date, which would be keep adding in, it would be little difficult to control. Can you make this, just for this query purpose, into two sheets.. one master inventory and one inventory consumption ... ? Thanks

Regards,
DILIPandey

<click on below 'star' if this helps>