Great tutorial. Just one question, how do we make it date specific? Like if we want to the stock balance to reflect the stock at a particular date? This can help keep a day to day summary of stock. Please help
For this you need to have latest Microsoft Excel version i.e Microsoft 365 subscription, If you are using old versions, you have to follow a different method, which is given in video description
Is there any option of searching in drop down option with some initials alphabets or numbers because if no. of SKUs are high then its taking too long to scroll
For this, you have to use the latest version of Excel, which has the search functionality in drop down. You can also try this mini inventory software for similar need: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OWhIbfHn1qc.htmlsi=4cCDLCnyCQpEDpAE
First, thank you for appreciating 🙏. Suppose, you have data in column A, Use this formula in cell B1 =RIGHT(A1,LEN(A1)-10) This will keep text or number by removing first 10 characters.
I a different sheet, create a data of item and its price. Beside the quantity column, insert amount column. In amount column, multiply the quantity with price (where get the price by using VLOOKUP or XLOOKUP).
Fantastic...Yeah wonderful amazing software... But I have tried to use it... Unfortunately Transaction Page is not working... Even though you fill up al required Information... Stock or out are not displayed on the page can You help me?
The SUBSTITUTE function in Excel is used to replace occurrences of a specific substring within a text string with another substring. It is particularly useful for text manipulation tasks.
Any new item should be entered in stock balance section first, before entering any in out transaction. After new item is added, it will reflect in item selection drop down.
In stock IN and Out range, items will repeat multiple times, so the straightforward method of 20-4 does not work as soon as you enter repeat item transaction.
Hello, i have downloaded the application , i extracted it, but when i try to open the application by clicking on buttom template there is an error message '' execution error 2147352571 (80020005) '' . PLease would you like to help me to solve the problem. Thank you .
Employee Shift change calendar Shift change 15 days a month two time Change shift one person, highlights night shift work to colour and night shift days highlights to another colour.😊 How it works