Hi Gurus,
can you please help me build a formula to my Warehouse Management Worksheet
I Have the following
Quantity Received
Quantity Used
Quantity on Hand
Then on my Other worksheet which I used to track the Lot No. and which a certain Material was used in
Quantity Dispensed; and
Quantity Returned
If I issue an Inventory Card to them they will fill out the Quantity Dispensed and The Quantity of the Material Returned
After they returned the Card I will also record it to my Lot Track Worksheet ( Quantity Dispensed; and
Quantity Returned)
I Like that as I record the Quantity Returned and Quantity Dispensed It will also reflect to my Quantity Used and Quantity on Hand of my other worksheet.
I would appreciate if you can help me figure out the right calculation combination of my problem.
Thank you so much.
Bookmarks