Inventory Management System in Excel using VBA - Don't buy it but make it.

You can buy a complete version of tool at my Buy-Me-A-Coffee website:

Inventory management tool in excel - Start from the scratch for beginner.

Free Download link for Practice File:

Step by step tutorial for VBA excel inventory management system

In this video I demonstrate how to create an inventory management template in Microsoft Excel. The template includes four tables: Adding new items, Import (=Stock In), Export (=Stock Out), Deleting items, Highlighting a selected item and statistic of inventory.

This video will learn the following (step by step):
1) How to start VBA coding for beginner - especially how to run Macro, saving files
2) How to create adding, correcting and deleting items by using VBA
3) How to create Error Handlers in VBA
4) How to use the Pivot table, Pivot Chart in Excel

Table of Contents:
00:00 Demonstration of Tool
01:06 Words for beginners
01:35 (Start) Open Excel file & Making Input Values
04:38 Making a button for VBA
05:26 (Start) Open VBA in Excel - making add item function
14:00 Making Clean-up VBA
15:17 How to Compile VBA code
17:29 Making a correction function in VBA
26:41 Making a new items function in VBA
28:49 Making a delete function in VBA
31:51 Making input/output button
37:45 Making a Userform in VBA
43:09 Making calendar function in VBA
45:40 Making highlight function
49:18 Making a Pivot Table
50:57 Making a Pivot Chart

[springdinampo]

Hi sir i just want to share that i successfully finished your video tutorial and also successfully finished it in excel. Thank you so much sir for taking time to show us your information for free. You are such a person! ❤

[rexbenemerito]

The very best YouTube Excel Macro Tutorial I've ever watched. You're very unselfish in sharing your expertise for Free. You are an angel to many Excel VBA Beginners. It is very comprehensive and covered a lot of topics including the Debugging process to ensure that the codes are running correctly and covered also many other important techniques. A thousand Likes and Thank you very much. God Bless you Brother.

[nairobi]

Thanks for sharing. There are so many concepts included. Great video.

[sadatarefinrafat]

This is some really great content. Highly practical and useful. Thanks

[happy-life]

Excellent! It is easy to follow tutorial. Thank you!!!👍👍👍👍👍

OMG thanks so much for this! It really helped me with building my Lab inventory system

[nadeesharathnayake]

A good video with easy steps. Thank you

[redhaakhund]

Excellent brother and for the cleare explanation. Do more videos please👍👍👍👍👍

[thetrungchu]

Thank you for your sharing. It's really a cool stuff.

[jovke]

Thanks a lot. I really appreciate the effort. Just keep going!

[Charlie-xqdl]

Thank you for sharing ❤ is it possible to add the start time and end time column? Similar to time tracker? Thank you so much

[GadgetsWorlds]

You're very good keep it up you will soon get many Subscribers and views. 👍

[successdavid]

Thank you for sharing this. it's really helpful I appreciate it.

[HowDidTheShowGo]

Great, easy to follow tutorial... Can you upload (or send to me directly) the XLS file w/ the VBA? I really like what you did and I'd like to include DATES (ReservedFrom & ReservedTo), which will add a lot of complexity but necessary for my use case. Thank you, in advance, for your consideration.

[seifashoushmedex]

this is a great tutorial just i faced one issue in the correction mode that once i click on a cell containg the thing i want to change and after correction its changing another cell with the same characteristics so imagine i have imported two products usually the correction is implemented in the one at the top

[Newboldheath]

Love this and built it today for my business, thank you! would you know if it is possible to capture the deleted line items and store in on a separate sheet? this would be very useful for historical records. also could you show me how to secure the document to prevent modifications but will allow data input into the management system

[luigisir]

hi and thank you for this really interesting video. a question... but how did you enter the calendar when selecting the date? Thanks for the reply.

[adhammohamed]

Hello sir, This Videos is amazing, thanks for sharing so much info. I want ask something if I have 5 Rows and I want to delete the 3rd row when I deleted The ID suppose to be 1 2 3 4 but the ID not change its like 1 2 4 5 and advice for this problem ?

[franklind.cobbinah]

thanks so much for such a wonderful workdone. i have followed your procedure and i have been able to produce a wonderful work, but i am trying to report the vba codes in different sheets in same workbook though i will change some few variables and name but the approach will be same. i have tried that but i get minor errors in the sheet 2 though i used the module 2. can your please help me with that?

[dinkahundessa]

Great tutorial and easy to follow. Keep it up, bro.