I need someone who can create an excel based delivery and inventory management system. I run granite and marble warehouse and need a way to better track deliveries and current warehouse inventory. I would like a system that would allow me to choose a customer name from a drop down box that would then auto fill the address, phone number and other contact information. then allow me to choose a material from a drop down box based on my current inventory in stock that would auto update the next pull down box with information relevant to the material chosen (lot number and number of slabs available).
basically i need a way to quickly add and update new inventory and then automatically take it out with a delivery function that pulls information from a customer spreadsheet and the inventory spreadsheet.