Excel program for ordering materials from the warehouse
Excel-based program for ordering materials from the warehouse in the manufacturing plant.The program is installed on different workstations in the manufacturing plant creating a whole network of such files.If it is necessary to fill in the necessary materials for production, the order from the file is sent via WI-FI to the ZEBRA mobile printer, which is located in the cabin of the wire chargers or at the warehouse worker.The paid label shows the logistics staff where, what and in what amount to deliver.The logistics department has one main file in which it manages the data, i.e. the link numbers, the attachment of goods to the department, the attachment of goods to the printer (some of them) on which the label should be printed, etc.All files are connected with each other via Power Query.Thanks to this, the logistics department can connect to all files at any time and download the data about all orders.Production in turn, in this way, connects to the main file, and after pressing the button "Update logistics data" immediately updates all data from the warehouse.