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


Contact details


E-mail       ian@xl-ian.com


Telephone          07773731429