hi, I already built a lot of similar modules.
I can suggest to you a module in Microsoft Excel which issue orders as follows: Preparation of three sheets: a client list, a product catalogue (prices) and a primary database with the orders. The user fills a form with customer ID and product ID and Excel shows complete order. by one click excel prepares PDF and update the order in the primary database. also, Excel updates the other reports at the same time.
About me
I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts.
Furthermore, I have experience in financial reports, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments, and bank reconciliation.