Visual Basic for Apps Jobs

I need my existing workbook to do more of the thinking for me. Right now each process is logged manually, but the column that should show who is responsible is blank. Your task is to insert the right data-analysis formulas so that, as soon as a process code or other key detail is entered, Excel automatically returns the correct “responsible” name. You may lean on lookup combinations, conditional logic, or any other native functions that keep the file fast and easy to edit; lightweight VBA is acceptable only if a purely formula-based route proves impossible. The sheet layout should remain intact—no moving columns or renaming headers. Deliverables • Working formulas (or compact VBA) that populate the “Responsibility” field for every current and future r...

I need a clean, reusable Excel workbook that lets me do two things from the same file. First, track daily attendance in a simple table that shows each employee’s name, check-in time, check-out time, and total hours worked. Second, have those attendance figures feed seamlessly into a salary-slip sheet so I can generate individual payslips at month-end without re-entering data. A formula-driven solution is my priority, but I’m open to lightweight VBA if it keeps everything one-click simple. The layout must stay fully editable, as different teams may add or hide columns later. Please deliver: • A master attendance sheet with automatic date handling and clear data-validation for time entry • Dynamic formulas (or macro) that calculate total hours per person per day and...

I need a seamless link between Xero’s API and an Excel workbook that automatically pulls the standard financial reports—Profit & Loss, Balance Sheet, Cash Flow and any other off-the-shelf statements—directly into Excel every day. No custom fields are required; the default columns Xero provides are perfect. The workflow should: • Authenticate securely with Xero’s API. • Drop each report into its own tab in a refreshable .xlsx file. • Allow a quick manual refresh in Excel (Power Query, VBA, Office Scripts, Python, or comparable approach is fine) in case I want an on-demand update. • Be simple to maintain if Xero tokens expire or if I need to adjust the date range. Deliverables: 1. Fully working connection script or add-in. 2. An E...

I need an automation solution to streamline several tasks involving data extraction, document generation, and data transfer. Requirements: - Extract Quantities, Prices, and Descriptions from an MS Spreadsheet BOQ. - Populate Cost Breakdown Sheets with the extracted data. - Generate Word documents: Work Order Forms and Installation Guides. - Transfer all relevant data to GoldVision CRM and MS Business Central. - Save all files in a newly created SharePoint folder. Ideal Skills: - Proficiency in MS Excel and Word. - Experience with automation tools (e.g., Power Automate, Zapier). - Familiarity with GoldVision CRM and MS Business Central. - Strong organizational skills for managing file storage in SharePoint. Looking for someone with proven experience in similar automation tasks. Please p...

I keep a master list of text in Excel and need the same strings to appear in set bookmarks inside a lengthy Word document. Manually updating each spot is getting out of hand, so I want to automate the round-trip. The core job is to write reliable VBA/macros that will: • Pull text data from specific Excel cells. • Match each cell to its corresponding Word bookmark. • Push the new text into Word at the click of a button (or Workbook_Open/Document_Open event). • Offer a simple “refresh” command so I can rerun the sync whenever the spreadsheet changes. • Handle errors gracefully (missing bookmark, blank cell, Word not open, etc.). Nice-to-have: If a bookmark’s text is edited directly in Word, a reverse sync back to Excel would be a bonus. ...

I have a short Excel VBA procedure called Sub AboutMe( ) that pops up a message box introducing me. I now need a clean, well-commented revision of that macro so the entire prompt appears in Hindi and also shows my contact information directly in the same MsgBox. Key points you must cover while editing the code: • Replace the existing mixed-language text with full Hindi phrasing. • Append a concise contact line (phone / email placeholder is fine; I will fill real data later). • Keep the procedure lightweight so it runs in any standard Excel workbook without additional references. Please return: 1. A .bas or .xlsm file containing the updated macro. 2. Brief instructions (one or two lines) on how I can change the contact string myself whenever needed. If you ca...

I have an existing monthly-budget workbook that already tracks income and savings, but the expense side is lagging behind. I need you to dive into the Expenses section, review the current cells and ranges, then build or correct the formulas so every expense line rolls up cleanly into a monthly total and feeds the year-to-date view. The sheet is laid out clearly, so this is mostly a formula and cell-reference task: SUMIF/SUMIFS, structured references, and a few conditional calculations for overspend alerts. No macros are required; pure Excel functions are fine. Once finished, I should be able to drop new numbers into each daily or weekly expense row and see the monthly forecast adjust automatically. Deliverable: the updated workbook with transparent, commented formulas in the Expenses are...

I need our simple logistics data-entry workbook turned into a smarter, mostly hands-off tool. Right now staff key information into a single base sheet, then we spend extra time copying, filtering and re-formatting that same data before it can be e-mailed to clients. I want to keep the base sheet as the only place anyone touches the raw figures, but have the rest happen automatically: • Guided data input – drop-downs, look-ups or forms that prevent typos and ensure each required field is filled. • One-click data output – macros or Power Query that transform the base data into clean, customer-ready sheets (PDF or XLSX) and save them to a specified folder, ready to attach to an e-mail. Because all finished files go out as e-mail attachments, the generated sheets mu...

I need a quantity surveyor - engineer who lives and breathes construction to build a suite of Excel workbooks completely from scratch. These files must let me: • Prepare detailed estimating sheets that roll into a clean, client-ready quote. • Track project progress, variations and key dates as a live project-management dashboard. • Generate daily site reports, monthly summaries and forward-looking cash-flow reports at the click of a button. • Monitor incoming and outgoing payments so I can see our real-time financial position. The final spreadsheets have to be intuitive for site staff yet robust enough for head-office reporting. Smart use of formulas, named ranges, drop-downs and conditional formatting is expected; VBA or Power Query is welcome if it keeps routi...

Cuento con una aplicación de cálculo de presupuestos desarrollada íntegramente en Microsoft Access y necesito llevarla al siguiente nivel. El proyecto consiste en añadir nuevas funcionalidades —entre ellas generación de informes claros y personalizables, automatización de tareas repetitivas y la creación de campos adicionales— además de corregir los errores que actualmente van apareciendo en uso diario. Trabajo y me comunico únicamente en español; no utilizo terminología técnica en inglés, por lo que todas las aclaraciones las comparto a través de breves vídeos explicativos. Quien se sume deberá sentirse cómodo siguiendo estas grabaciones y devolviendo avances...