There are three simple steps you can take to create a warehouse software in Excel. Using VLOOKUP and Sumifs If you need more advanced training or a program, just follow us and write in the comments
It is a good template. Thank you. But one problem is... When I add same item on output twice or multiple times (once IN and other times OUT), the quality on "Remain" sheet will automatically lookup the value of Quantity on "Main" sheet just keeping the sequence only even if the items are not same. Any solution for this?
Hi, Great video’s I would like help how to solve a problem, how to assign, tables, ranges, Vlookup etc. Eg: What lures are best to catch different fish. Select type of fish from dropdown list. Eg: Cod, Trout, Bream Select lure type from dropdown list. Eg: Spinnerbait, Soft plastic, Hardbody Have a list of Lure Brands for each type of fish. By selecting fish type Eg: Cod, Lure Type Eg: Spinnerbait, Would bring up the list of spinnerbait brands for Cod in the third column.
The teacher doesn't teach well. Poor teaching. Doing everything by himself without considering other people watching. Very poor. Do not understand anything