Hi Susan, My name is Dov and I can suggest to you a module in Microsoft Excel which issues invoices/orders as follows: Preparation of three sheets: a client list, a product catalogue (prices) and a primary database with the invoices and the orders. The user fills a form with customer ID and product ID and excel shows complete invoice/order and converts it to PDF file. At the same time, Excel updates the invoice/order in the primary database and updates the other reports as well.
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.