Inventory Management System Part 4 - Creating Sale History Sheet - Vlookup- Dropdown - Sumproduct

This is the 4th video series of Inventory Management System.
In this video is showing how to create the Sale History table with the VLookup function for Description, Second Language, Category and also use IF function to create the Time recording for Upload Date and Upload Time. Max function is used to create an auto Invoice Number for the Invoice.
After scanning the barcode the Description, Second Language and Category will pop up into the Sale History table and you just copy and paste quantity, price, and discount into the table then the total will be calculated.
The purpose of creating this Sale History table is to store all sale history along with the time recording.
There are serveral parts of videos will be posted on YouTube and Facebook, so please stay with us.
Welcome any comment and Thanks for watching.

Excel Inventory,Inventory,Inventory Management System,Inventory Control,Invoice,How to create Invoice,Invoice in Excel,Invoice Tamplet,Sale,Sale History,Time Recording,