Visual Basic para aplicaciones Jobs

Necesito agilizar un proceso interno llamado MTM. Hoy lo ejecuto manualmente y pierdo demasiado tiempo en: • organizar datos • realizar cálculos complejos • generar reportes de salida Quiero que todo eso ocurra con un único clic desde un botón incrustado directamente en la hoja de Microsoft Excel. Alcance inmediato (entrega en 1-2 días): 1. Revisar conmigo el flujo actual de MTM para identificar qué pasos pueden convertirse en código VBA sencillo. 2. Crear las macros necesarias que automaticen los tres puntos anteriores sin alterar la estructura de mis archivos. 3. Insertar un botón visible y descriptivo dentro de la hoja que dispare todo el proceso. 4. Probar la solución con un pequeño set de datos y a...

I need a clean, professional‐looking Excel dashboard dedicated to financial analysis, with the emphasis on budget forecasting. All underlying sheets are ready; what’s missing is an intuitive front-end that lets me monitor how actual spending measures up against projected figures at a glance. The heart of the job is visual: I want clear, well-labeled graphs and charts that summarise monthly, quarterly and year-to-date performance. Think dynamic column charts for variance, simple line charts for trends and perhaps a waterfall to show cumulative impact—whatever conveys the story best. Everything must update automatically as fresh data is pasted into the source tables. You are free to use the Excel tools you prefer—PivotTables, named ranges, Power Query, slicers, even a...

I’m putting together a personal-finance coaching workbook and need an Excel expert to turn my outline into a polished, user-friendly file. The core of the job is a 12-month layout (January through December) with a clear yearly dashboard that automatically rolls up every figure. Users will open this file on Excel for Office 365 and Excel Online, so every formula, table, and link has to behave perfectly in those environments and display well on phones as well as desktops. Each monthly sheet should include sections for Income (broken down into Salary/Wages, Investments, and Other Income), Expenses, and an at-a-glance Net Total. All totals must flow up to the summary page without complicated array formulas or VBA; simple SUM, SUMIF/SUMIFS, and basic links are fine so clients can audit o...

I need multiple Excel spreadsheets brought together into one clean, automated workbook that updates itself and delivers clear reporting and analysis. The source files hold similar data structures, so the key tasks are to merge them reliably, build VBA macros to refresh the data with one click, and present the consolidated figures in easy-to-read summary sheets. What success looks like • A single master file that pulls from all current and future source sheets without breaking existing formulas • Automated macros that handle data import, de-duplication, and error checking • Well-formatted summary tabs that give me instant insights instead of manual copy-paste work When you reply, focus on the experience you have building comparable Excel solutions—particu...

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

Project Title: Excel Spreadsheet – Builder Retention Tracking I run a commercial plumbing business in Australia and need an Excel spreadsheet built to track builder retentions across multiple projects. In construction, builders typically hold 5% retention from the contract value. Usually 50% is released at practical completion and the remaining 50% after the defects liability period (typically 12 months). The spreadsheet needs to help us track how much retention is being held, when it should be released, and highlight when payments are overdue. Main Sheet – Retention Register Each row will represent one project. Columns required: Project Number Project Name Builder / Client Contract Value Retention % Total Retention Held (auto calculation) Practical Completion Date...

I have a Windows Excel workbook (VBA) that calls a Python FastAPI server (business logic is server-side). The current version works, but I need it converted into a paid, production-grade software with maximum possible security on the client side to prevent unauthorized usage and bypassing. I’m a developer but not a cybersecurity expert. I want you to design and implement a strong licensing + anti-tamper system. Current setup Write "read" in your first line of your proposal. Excel (VBA) client on Windows FastAPI server (Python) VBA currently calls server directly What I need (must-have) Paid licensing enforcement Users must be licensed/paid before usage is allowed Support: active / expired / revoked / banned Maximum security client architecture I strongly prefer ...

Our entire pricing catalogue currently sits in a single Excel workbook, but we have a new CMS system that contains a new spreadsheet structure that will serve as the future-proof version of our pricing system. I need every element moved across—product and service descriptions, image links, materials, equipment, labour rates, and any related look-ups—while reshaping the data to fit the new column order, field names, and calculation logic that lives in our new program. Because the new template differs from the old one, this is more than a simple copy-and-paste job; it calls for significant data transformation. You may need to: • split or merge fields, • convert formulas into more efficient functions, • normalise units and naming conventions, and • ...

**Title:** Need Expert to Create Critical Path Method (CPM) Schedule in Excel for Construction Project **Description:** I’m looking for an experienced construction planning professional who can create a **Critical Path Method (CPM) project schedule** for a construction project using **Microsoft Excel**. The goal is to clearly map the **entire project timeline**, dependencies between activities, and the **estimated completion time for each stage of the project**. **Scope of Work:** • Create a **complete CPM schedule** for a construction project • Provide **activity breakdown (tasks and sub-tasks)** for the project • Show **start date, finish date, duration, and dependencies** for each activity • Identify the **critical path** clearly • Calculate **total p...

I am putting together a comprehensive inventory-management report that draws on several different raw data sources and I need your help building it in Advance Excel, enhancing it with Macros/VBA automation, and visualising the results in Power BI. Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design...

I have an existing Excel workbook that I use for staff rostering. At the moment every step is manual, so I want the entire process wrapped into one push-button VBA routine. When I click the button the macro should: • Allocate each employee to the required shifts • Detect any conflicts such as overlapping hours or breaches of contracted limits • Check every assignment against the applicable awards and internal policies, preventing non-compliant rosters from being published The file is already structured; your job is to build the automation logic, wire it to a clearly labelled button, and return a macro-enabled workbook (.xlsm) that produces the finished roster on demand. Please comment the code so I can maintain it later and include a brief note or screen recording th...

I need an Excel workbook enhanced with VBA that can pull sales data directly from our database, crunch the numbers automatically and present clear, on-demand reports. The focus is pure analysis and reporting—no manual copy-pasting, no repetitive filter steps—just hit a button and the figures are there. Here is what I’m after: • A reliable VBA routine that connects to the database, refreshes the data set, and stores it in well-structured worksheets. • Automated calculations for common sales KPIs—revenue by product and region, period-over-period growth, averages, and any additional measures you suggest that add quick insight. • Polished summary views (pivot tables or a lightweight dashboard) that update whenever the refresh runs, so management can ...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

Projet : Automatisation de la Conception de Guides Genou 3D Ce projet vise à automatiser plusieurs étapes critiques du flux de traitement d'un cas de genou 3D, spécifiquement axé sur la conception de guides orthopédiques. L'objectif principal est de réduire la variabilité, d'améliorer la robustesse, d'accélérer les délais et de minimiser les erreurs humaines. Les défis incluent la gestion de différents formats de fichiers (STL, SLDPRT), la création de géométries de référence spécifiques à chaque client, l'assemblage précis de pièces, la conception paramétrique de guides, l'application d'inscript...

I already have an Excel system with a Measurement Sheet (input) and Dashboard. I need a small automation to generate an RA Bill sheet automatically from the measurement data. Requirement: RA Bill should be generated automatically based on the selected RA number. Each Item No. should appear as a heading with its BOQ description. Under each item, the measurement rows should appear automatically from the Measurement Sheet. The table should have these columns: Description | Unit | N1 | N2 | Length | Width | Depth | Qty The Description column should show location/sub-item from the measurement sheet. When entries for the same Item No. end, the system should automatically show Total Quantity. After the total row, the next Item No. section should start automatically. The number of rows under each ...

I’m looking for an expert who can install the necessary components for automating and scripting workflows between Excel and OneNote, then walk me through how everything works. My priority is getting the automation up and running smoothly, followed by clear, hands-on training so I can maintain or adjust it myself later. Deliverables • Fully installed and configured automation solution connecting Excel and OneNote • Live training session(s) showing how to run, modify, and troubleshoot the scripts • Quick-reference documentation or a short recording summarising the key steps and best practices If you’ve built similar Excel-to-OneNote automations before and enjoy teaching, I’d love to hear how you would approach the setup and training.