Guest viewing is limited
  • Extra Credits Promo for Resources !!!

    Usually the exchange rate was 1x10 (100 $ >> 1000 Credits),
    With this new promo you get an exchange rate 1x10 !
    For example:

    075 $ >> 0750+100 = 0850 Credits

    100 $ >> 1000+200 = 1250 Credits

    125 $ >> 1250+400 = 1650 Credits

    150 $ >> 1500+800=2300 Credits

    This promo is valid until 2nd October, 2021

    Don't miss this offer and get your credits now!

     >> Get VIP <<

     >> Buy credits now <<

ReD DeViL

👑 Administrator 👑
Staff member
CmTeamPk King
CmTeamPK Boss
CmTeamPk Developer
Jul 18, 2020
2,959
521
Ofline
image-10-768x432.png


Stock & Inventory Management In Excel – Download Template

Friends, it is a little difficult to manage Stock & Inventory in Excel without VBA, so we are sharing with you a Fully Automatic Amazing Stock & Inventory Management Sheet of Excel in which we have not used any VBA Code, i

n this seat you can easily You can manage the stock and inventory of your Sales and Purchases from After watching the demo of this Stock Sheet, you will know how automatic this sheet is and how much work is done,

below is the video in which you can see the demo of this Stock & Inventory Management Excel Sheet and in the video we have made this seat.

The complete process is explained step by step, by watching the video, you can easily make this seat yourself.


image-11-768x432.png

Some Features of This Stock & Inventory Management Sheet​

  • You can customize this seat according to you.
  • It has total 4 seats Dashboard Sheet/Purchase Sheet/Sales Sheet/Stock Sheet. From the Dashboard Sheet, we will enter Purchase and Sale, which will automatically go to the Sales and Purchase seat.
  • There is no need to pre-prescribe the item name in the stock seat, as soon as we enter a new purchase, the stock seat will be updated automatically.
  • If you sell more than the stock, then automatic (Stock Not Available) alert will be received, for which we have made tremendous use of Vlookup + if formula.
  • When you enter Sale in the Dashboard Sheet, there will be no need to go to the Sales seat to see what was the bill number of Last Sale, the bill number of Last Sale will be automatically detected.
  • On the seat of Sales and Purchase, the latest entry will be saved above i.e. the old entry will be automatically shifted down.

Important NOTE​

To create this stock sheet, we did not use VBA code, just recorded 2 small macros, so you just have to keep one thing in mind when saving the file, by selecting Excel Macro Enabled Workbook from the list of Save As Type saving so that it works properly when you open this workbook again.

stock-sheet-min.png

Download Stock & Inventory Management In Excel – Download Template




 
Top