Visual Basic pro aplikace Jobs

My current bookkeeping is scattered and I want everything organised in one Excel file that lets me record every income and expense once and then shows me clear, ready-to-print financial reports automatically. Scope of work • Build a clean data-entry sheet dedicated to Income and Expenses, with columns such as date, category, description and amount. • Create the behind-the-scenes formulas that roll those entries into running totals, monthly and yearly summaries, and an overall balance. • Add a separate “Reports” tab that pulls the data into at least a profit-and-loss style summary plus any other insightful views you think would help me monitor cash flow quickly. Dynamic tables, slicers or simple charts are welcome if they keep the file easy to use. •...

I want to turn a workbook that currently relies on manual typing into a push-button process. The flow is simple in theory—data comes from people keying numbers or text straight into Excel—yet it’s time-consuming and error-prone. Here’s what I need: when a user opens the file, they should be guided through an organised form or other intuitive interface that writes their input to the correct sheets, performs validation, and stamps a time-and-user log automatically. As soon as the new records land, Excel should run the built-in statistical routines I specify (mean, standard deviation, t-tests, simple regressions and similar core stats) and update all summary tables, charts and printable reports without further clicks. I’m comfortable if you lean on VBA, mac...

Cuento con una aplicación de gestión escrita en Visual Basic 5 que trabaja sobre una base de datos Access 97. Quiero modernizarla sin perder funcionalidad, añadiendo de forma prioritaria la facturación electrónica que será obligatoria en 2027. La actualización también debe incluir un módulo de correo electrónico completamente integrado. Necesito que permita: • Enviar recibos y facturas directamente desde la aplicación. • Gestionar boletines informativos a los clientes. • Adjuntar archivos de cualquier tipo (PDF, XLS, imágenes, etc.). Una vez cubierta la parte de e-mail, quiero habilitar el envío de notificaciones mediante la API de WhatsApp Business, con plantillas editables y...

We have an existing Excel file with 10 macros already implemented. We need to add one more macro to the file. The task involves capturing data between two specified columns using a formula (e.g., "="). Further details will be shared directly with the freelancer as this is an office-restricted file. The work should be completed within a week.