Visual Basic für Apps Jobs

I need a well-structured Excel workbook that lets me drop in raw customer data and instantly see meaningful insights. The core objective is data analysis focused specifically on customer behaviour, so the file should make trend analysis and segmentation analysis both quick and intuitive. Here is what I have in mind: • A clean, instruction tab where I can paste or import new customer records (CSV friendly). • Automated tables, formulas, or Power Query steps that transform that raw feed into an analysis-ready data model. • Pivot tables, charts, or a compact dashboard that highlights purchase trends over time and breaks the customer base into clear segments I can act on. • Everything unlocked and documented so I can tweak filters, date ranges, or add new fields la...

We are converting a mature, commercially deployed Excel-based financial/audit automation application from VBA to Python. The Excel workbook front-end and custom ribbon stay; all processing logic moves to a Python engine running behind Excel. THE SYSTEM: • ~56,000 lines of VBA across a main workbook and add-ins, developed and patched over 15+ years • Modules include: data import and mapping wizards, journal/adjustment engines, configurable settings panels, analytical calculations, multi-step report generation wizards, sampling tools, and a cash flow statement engine • Full installed environment, source code, and user documentation will be provided under NDA SCOPE OF WORK: 1. PLANNING PHASE: Analyze the VBA codebase and produce a technical planning document — module inv...

I want to clean up and speed up the way we handle vendor and customer invoices. Right now the flow touches SAP FI, MM and SD as well as a set of Microsoft Excel workbooks that staff use for preliminary checks. The immediate priorities are: • Accurate data entry and verification at each step, so master data, PO numbers, tax codes and payment terms always match. • Eliminating as many repetitive keystrokes as possible—whether that means SAP scripting, BAPIs, Fiori apps, VBA macros in Excel, or an RPA bot that can move between both platforms seamlessly. You’ll start by mapping the current steps, highlight where errors or double-entry happen, then build and test the automation or validation logic. A concise hand-over guide and annotated code/scripts are part of the...

My VBA-driven workbook suddenly throws an error on Windows 11 with Office 2019. I need someone who can jump in right away, locate the glitch, and patch it within the next couple of hours. I will send the workbook and a brief note on the steps that trigger the failure. Once you reproduce the problem, please clean up the code, make it robust for this environment, and send the corrected file back along with a short summary of what you changed and why. Deliverables • Repaired Excel file with fully functioning macro • One-paragraph changelog outlining the fix If you are confident with VBA in Office 2019 and can start immediately, this should be an easy win for you and a quick resolution for me.

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

I need a single Excel workbook tailored for our mechanical department that can automatically turn raw operational data into clear summary reports. The main purpose is to generate three report types—Monthly Performance, Maintenance Schedule, and Inventory—without extra manual manipulation, because the engineers who will use it have limited time to tinker with formulas. Here’s what I have in mind: • One ​input sheet where engineers can paste or import daily data. • Backend formulas, pivot tables, or VBA (your call) that clean, sort, and calculate the required metrics. • Three dedicated report tabs—Performance, Maintenance, Inventory—that update instantly once new data is entered. Acceptance criteria • All calculations refresh with a single ...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

I need an Excel-driven product configurator that pushes parameters to Autodesk Inventor and automatically outputs the corresponding 3D model. The workbook will present a handful of predefined options—basic length, width, height and material selections—so the user can pick values from drop-downs, press a single button, and watch Inventor build the part or assembly in the background. Scope • Create a clean, password-protected Excel interface (xlsm) with clearly labelled input cells and validation lists for each option. • Link those inputs to an Inventor template through VBA, iLogic, or Inventor’s API—whichever is most robust—so the model regenerates instantly and saves to a specified folder. • Include error handling that alerts the user i...

I want to give our in-house Microsoft Access application a cleaner, more intuitive interface without touching its underlying tables, queries, or core VBA logic. The test assignment will be a single form; once that looks and feels right we will apply the same treatment to the rest of the system. What needs attention • General layout—better alignment, comfortable spacing and padding, and clearer grouping of related fields. • Navigation—smarter use of tabs so users reach the data they need in fewer clicks. • Visual polish—modern button styles with meaningful icons, consistent font types and sizes, and a cohesive color scheme that reinforces hierarchy and readability. I will supply the current .accdb, a style guide of our corporate colors, and notes on ...

I keep a growing set of records in Excel and I want to stop typing everything straight into cells. Instead, I need a small automation tool—built directly inside the workbook—that pops up a clean, user-friendly form, lets me key in each new record, and then stores the information in the correct table automatically. Core needs • Form-based data entry only; no direct cell editing. • Data are entered manually, so the form should guide the user with drop-downs, date pickers, and basic validation to prevent typos or blanks. • Once a record is submitted, the macro should place it in the next empty row of the master sheet and, if possible, time-stamp the entry. • A simple “Edit existing record” function would be a bonus but is not essential fo...

I’m looking for an Excel-based solution that lets me maintain a fully linked set of financial statements without touching a calculator. The workbook should open to a clean, user-friendly dashboard where I can enter raw transaction data (or paste it in) and instantly see an updated Balance Sheet as well as an Income Statement, Cash-Flow Statement, and Statement of Changes in Equity. Core deliverables • Balance Sheet • Income Statement • Cash-Flow Statement • Equity Statement Key features to build in • Automated calculations that flow through every schedule and roll forward ending balances automatically. • Clear, presentation-ready graphs and charts that refresh with each data update so trends are visible at a glance. • Solid data-va...

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...