Visual Basic para aplicaciones Jobs

I am seeking a high-caliber Finance Professional or Chartered Accountant to specialize in the preparation and analysis of Cash Flow Statements. This is a critical task requiring someone who can move beyond basic accounting to interpret transactional data, reconcile movements, and present a clear picture of liquidity. Scope of Work: You will be responsible for the end-to-end execution of: Cash Flow Statements: Preparation of accurate, audit-ready statements based on current financial data. Liquidity Analysis: Identifying trends, variance, and cash position insights to assist in management decision-making. System Integration: Utilizing Zoho Books to extract and verify transactional data. Reporting: Presenting findings in a professional, executive-level PowerPoint presentation. Required...

I need a VBA-powered, macro-enabled workbook that lets a user press a single button to pull raw data from fixed worksheets, crunch it, and output a polished summary report. The flow is entirely manual—no scheduled tasks—so the code should run only when the user triggers it. Here is what I picture: • A clean interface element (ribbon button or clearly labeled worksheet control) that launches the macro. • The macro gathers data from predefined tables, applies any necessary filters or calculations, then populates a separate “Report” sheet with formatted tables and charts ready for printing or PPT export. • Well-commented VBA code so I can adjust ranges or add new fields later. Please build the workbook in the current desktop version of Excel for Window...

I need a small desktop tool that pulls test results from my existing Microsoft Access database, funnels the data through Excel where the calculations and layouts already live, and then exports a polished Chemicals Tests Analysis Report as a PDF at the click of a button. Everything must run seamlessly inside the Office environment—VBA, Access macros, or an embedded .NET add-in are all acceptable as long as the final workflow is fast and maintenance-friendly. The interface can remain simple: a form where I choose the batch, confirm the parameters, and hit “Create Report”; the program should handle all data joins, call the Excel template, populate it, and save or print the finished PDF. Key deliverables • Automated routine that connects to the current Access tables...

I need an Excel-based log sheet for trip details plus a user-friendly console that drivers can open, fill out, and save without touching the underlying tables. The workbook must: . Printable Excel sheet and • Guide each driver through mandatory fields with clear data validation so missing or wrongly formatted entries are blocked on the spot. • Perform automated calculations—totals, mileage differences, fuel cost per kilometre, and any other running sums that make end-of-day reporting effortless. • Offer an instant search and filter panel so I can pull up any past trip or driver record in seconds. I’m happy with a protected sheet interface or a VBA userform—whichever delivers a clean, button-driven experience for non-technical users. Final delivery ...

My current invoicing workbook needs to move from “mostly manual” to fully automatic. The core of the job is to build an Excel-based solution that: • Instantly generates a clean invoice sheet from order data • Pulls and pushes data through reliable import/export routines (CSV, XLSX or Power Query—whatever is most robust) • Performs every total, tax and discount calculation without the slightest manual tweak On top of that foundation I need two extras that matter a lot to the workflow: switchable custom templates (so I can brand invoices for different business lines) and a live connection to mainstream accounting software. Think of the integration as a one-click post of the final invoice straight into the ledger, keeping GL codes, customer IDs and pay...

I need a fully-functional severance calculator built directly in Microsoft Excel so our HR team can run it on Windows machines without additional software. The worksheet should allow users to enter the following variables in clearly labelled input cells: • Years of service • Age of employee • Job position • Job grade • Short-term incentive eligibility Province Based on these inputs the file must return the correct statutory and common-law severance entitlements for Canadian employees, following current federal and provincial guidelines. All formulas should be transparent, with assumptions documented in a hidden but unlockable sheet so we can update rates later. Deliverables • Unlocked Excel workbook with user-friendly input area and results da...

I have an Excel workbook packed with productivity figures that needs to tell its story clearly in an upcoming presentation. My audience is non-technical, so visuals must be intuitive: clean tables with strategic highlights rather than complex charts. Here’s what I need: • A set of formatted tables that surface the key productivity metrics—think conditional-formatted cells, sparklines, or color-coded variances—so trends and outliers pop at a glance. • An easy-to-follow layout: summary at the top, detailed breakdowns below, each section clearly labeled for quick navigation when I’m presenting. • Light automation where it helps (simple formulas, named ranges, perhaps a few slicers) so I can refresh the data without re-doing the design. Accept...

I have a sales performance sheet. I want an experienced person who is specialized in advanced Excel formulas and who can automate the sheet. The sheet is already automated. Some of the formulas are not working, and I want to add some more stuff into it, so I need someone who can actually do the stuff.