This post contains the download of a stock control spreadsheet. The spreadsheet is used to manage the level of sweets in stock. As more sweets are ordered, and sweets are sold the spreadsheet keeps a record of the stock remaining.
The spreadsheet is unprotected making the formulas and VBA used available to see. The spreadsheet includes the following Excel techniques;
- VBA code to perform much of the functionality
- A command buttons to initiate the macro to deduct the number of sweets sold, or add the number of sweets ordered
- A table to create a dynamic range for future orders and sales. A Total Row has also been used to sum values
- Vlookup functions to retrieve the sweet names from the stock sheet after the product code has been entered
Download the Excel Stock Control Sheet.