Visual Basic für Apps Jobs

I have data sitting in Excel that I need turned into polished, ready-to-share reports. The core objective is simple: transform the raw sheets into clear summaries that decision-makers can read at a glance. If the best way to get there involves pivot tables, dynamic formulas, or a small VBA routine, I’m happy to follow your lead—the result just needs to be accurate, fast to refresh, and visually tidy. Deliverables I expect: • One or more report tabs inside the workbook, formatted for print and screen • Any supporting calculations or automation kept neatly in the same file (or a companion template) • A quick note or video showing me how to refresh the reports with new data I can send a sample of the current workbook as soon as we agree on an approach. Let me kn...

I already have every worksheet, range and formula laid out; what I’m missing is a rock-solid VBA routine that will apply them exactly the same way each time I refresh my data. I work in Microsoft Excel and the recorder gives me a script that looks perfect on the first run, but when I bring in new data and launch the saved macro, references shift and the conditional formats go out of sync. Here’s what the finished code must do: • Loop through several predefined sheets, drop the right formulas into the right columns and lock them in place. • Add formula-based conditional formatting that highlights cells whenever a value climbs above my threshold or when specific text appears—no icon sets or data bars, just clean colour fills. • Keep all rules and referen...

I have run into the classic “The module ‘C:Program FilesCommon FilesMicrosoft SharedVBAVBA7.1’ failed to load” message in Microsoft Excel. It showed up right after I added a Microsoft-official add-in, and now every macro call throws “Sub or Function not defined.” What I need from you is a clear, reproducible fix that gets Excel opening the VBA editor again without errors and restores my existing macros. I’m open to a guided repair, a quick remote session, or a precise checklist I can follow—whichever gets the job done safely and quickly. Please be comfortable troubleshooting Office installations, repairing missing or corrupted DLL dependencies, and rolling back or re-registering add-ins. If extra tools (e.g., Process Monitor, Depe...

My Excel workbook is fully locked—workbook structure, worksheets, and the VBA project are all password-protected—so I can’t run the macros inside it, let alone see or edit the code. Nothing in the file is currently accessible to me. I simply need the protection removed so that the existing macros execute normally again; no other changes are required. If you have a reliable technique or tool to lift all the protection layers safely without corrupting formulas, code, or data, I’d like you to: • Return an identical copy of the workbook with every sheet, project element, and macro fully available. • Provide a brief note on what you did (for my records), or clear step-by-step instructions if direct unlocking is impossible for privacy reasons. The job is co...

When I try to run a macro in my Excel-based workbook (Office 365), I immediately receive a “Compile error: Sub or Function not defined” followed by an additional message that failed to load from C:Program FilesCommon FilesMicrosoft SharedVBAVBA7.1 I need someone who can: • Diagnose why that DLL isn’t being picked up, whether the issue is a missing reference, corrupt registry entry, broken Office installation, or a flaw inside the workbook’s VBA project. • Repair the root cause so the workbook’s macros compile and execute without errors on my machine. • Explain any steps I should follow (e.g., re-registering libraries, adjusting Trust Center settings, repairing Office) so I can reproduce the fix if I move the file to another comp...

Every week I’m compiling the same operational numbers by hand and it’s time-consuming. I’m looking for someone who can turn that routine into a single-click Excel solution using VBA macros, Power Query, or any other built-in automation you trust. The goal is simple: feed in raw operational data and walk away with a fully formatted report ready for management review—charts, KPIs, and any calculated metrics included. What I will provide • Sample raw data files (CSV/XLSX) and the current manual report layout. • A short list of the key operational metrics I track. What I need from you • An Excel workbook (or add-in) that pulls in the fresh data, cleans and reshapes it, then produces the finished operational report automatically. • Well-commented c...

I need an expert in Excel, particularly with VBA, to write fresh codes for my project. Key Requirements: - Primarily dealing with mixed data. - Proficient in Excel Advanced and VBA coding related issues. - Experience in error troubleshooting and automation. Ideal Skills: - Strong problem-solving skills. - Experience with data entry, validation, and report generation automation. Looking for someone who can quickly identify and resolve issues to streamline my workflow.

I need an Excel VBA developer to assist with data analysis and reporting, specifically using financial data. The primary focus will be on creating VBA scripts for budget tracking and developing Management Information System (MIS) templates. Ideal skills and experience: - Proficiency in Excel and VBA - Experience with financial data manipulation - Strong analytical skills - Ability to create automated reports and custom templates - Experience in budget tracking and MIS template development

Poseo un archivo de Nota de Entrega en Excel que quiero llevar al siguiente nivel mediante VBA. Necesito: • Numeración automática: cada vez que genere una nueva nota debe aparecer el siguiente correlativo (0001, 0002, 0003…), sin que tenga que tocar nada más. • Botón “Nuevo Registro”: al presionarlo debe limpiar todos los campos de la nota, dejarla lista para el siguiente cliente y disparar la nueva numeración. • Base de datos de productos: deseo manejar mis artículos por código. Al seleccionar el código deben completarse descripción y precio de forma inmediata. Esta base debe quedar en un archivo externo vinculado para que pueda actualizarla sin abrir la plantilla principal. Entrego mi a...

I have a straightforward Visual Basic for Applications project that is almost finished but still needs a reliable pair of hands to get it over the line. The core logic is in place; what I’m missing is the polish—tightening up the code, resolving a few lingering errors, and making sure everything runs smoothly from start to finish. You’ll be working strictly in VBA, so please come prepared to dive straight into modules, user-defined functions, and the usual debugging tools. The host application can be Excel, Access, or Word; if you’re comfortable across all three, great—otherwise let me know which environment you prefer and we’ll align the files accordingly. Here’s what I need from you: • A fully functioning macro with any bugs ironed o...

I need a property portfolio tracking sheet created on Google Sheets, enhanced with VBA-driven macros and dynamic graphs that lets me track every property in real time. The sheet must make data entry painless, spin up clear reports at the click of a button, and run quick analyses without my touching a calculator. Everything—raw figures, summaries, and charts/graphs—should live inside the file; I do not want it pulling information from websites or local files. Core data to capture for each address will be the current market value, monthly, year, 10, 20 and 30 year growth predictions based of input growth %, on going expenses with council rats, water, strata, insurance and ongoing or one-off maintenance costs. From there, your code should automatically calculate totals, cash-flow...

I have an Excel workbook that houses customer-specific data and I need it to calculate material costs automatically so I can turn around accurate quotations in minutes, not hours. The core of the job is to build (or rebuild) complex formulas and, if needed, a small underlying model that pulls the right rates, quantities, mark-ups and taxes for each client scenario. The worksheet already contains raw customer information; what’s missing is the logic that translates that data into reliable cost breakdowns. I’m expecting robust functions—INDEX/MATCH or XLOOKUP combinations, dynamic array formulas, maybe some helper tables—to validate entries, perform the cost roll-ups and present a clear total ready for the quote. When we’re done I want: • One self-c...

I have a historical sales dataset that I want turned into clear, forward-looking insights directly inside Excel. The main goal is to build a predictive model that flags upcoming sales trends so I can plan inventory and campaigns with confidence. Your task is to: • Clean and structure the raw sales data if needed • Create an easy-to-refresh predictive model (regression or time-series—whatever suits the data best) using native Excel tools such as Power Query, Data Analysis ToolPak, or simple VBA where appropriate • Present the findings as intuitive charts and a short narrative that spells out what the numbers mean for future sales Acceptance criteria: the workbook must run without external add-ins, clearly highlight projected trends for the next periods, and ...