hi, Yes, I can do it and I built a lot of similar modules.
I can suggest to you a module in Microsoft Excel which issue quotations as follows: Preparation of three sheets: a client list, a product catalogue (prices) and a primary database with the quotations. The user fills a form with customer ID and product ID and Excel shows complete quotation. by one click excel prepares PDF and update the quotation 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.