Microsoft Excel Consultant
The XL-ian Simplified Stores System
The main screen
Clicking on the Cell opens a drop down box with a list of tradesmen.
Once the tradesman has been selected the date and time is recorded.
The “Machine” and “Part Number” cells are drop down lists. Selecting the “Part Number” automatically fills in the “Part”.
Enter the quantity of “Parts” taken from the store.
Should “Parts” be returned to the store they are entered in the “QTY RTN” cell and the “ACT QTY” (actual quantity) cell is adjusted.
The cost of this stores system is £100