This is my new shopping mall.
https://excellatte.etsy.com
You can buy a complete version of tool at my Buy-Me-A-Coffee website:
https://www.buymeacoffee.com/exceltutorial/e/150043
You can apply 5 new practical features in your Excel files.
However, this tutorial is used the previous inventory management excel file.
Free Download link for Practice File:
https://www.buymeacoffee.com/exceltutorial/e/157917
Step by step tutorial for VBA excel in inventory management system
In this video, it demonstrates how to create 5 different useful features for an inventory management template in Microsoft Excel. After this video, your tool can be improved it a lot.
For your information:
In the previous video, the template includes 5 parts: Adding new items, Import (=Stock In), Export (=Stock Out), Deleting items, Highlighting a selected item and statistic of inventory, Pivot table and Pivot Chart, etc.
This video will learn the following (step by step):
1) How to create Save as File in VBA coding
2) How to create 3 different search functions using VBA
3) How to create Print function (incl. PDF file) in VBA
Table of Contents:
00:00 Demonstration of Tool
01:44 Save as File Function in VBA
08:18 Search Function in UserForm in VBA
18:33 Search Function in Sheet in VBA
27:41 Advanced Filter Search Function in VBA
39:45 Adding Hyperlink in Excel (No VBA)
41:29 Adding Print Function in VBA