Updating Inventory Totals

[francoiscj1]

I have an inventory worksheet and I would like to do the following:

1. I would like the current inventory quantity (on hand) (Column E) to increase when inventory is received (Column J) and decrease when inventory is issued (Column L) by item code (Column B).

2. I would like a vlookup formula to extract data (B9:O36) by date (F5).

Thank you for your help.

 

[RasGhul]

Hi we could find a solution easier if you could post some sample data.

 

[francoiscj1]

Column B Date
Column C Item Code
Column D Item Name
Column E Item Description
Column F Current Inventory Qty 10 + 10 - 5
Column G Current Inventory Total 10
Column K Receipt Qty 10
Column L Receipt Total 10 (Receipt Qty will be added to Current Inventory); Formula to be modified: (=IF(C9=C8),"",(C:C,C9,K:K))
Column M Issuance Qty 5
Column N Issuance Total 5 (Issuance Qty will be subtracted from Current Inventory); Formula to be modified: (=IF(C9=C8),"",(C:C,C9,M:M))

For Vlookup: Date is in cell F5 and data is B9:P35



​

 

[beepetark]

please send me ur file attachment so that we can help you out

 

[francoiscj1]

please send me ur file attachment so that we can help you out

How can I attach my file?

 

[francoiscj1]

I don’t see an option to upload my file for review.

 

[RoryA]

You can't attach files: https://www.mrexcel.com/forum/about-board/508133-attachments.html