Visual Basics för apps Jobs

I need an expert in Excel to create a macro that automates the process of extracting data from one file, validating it, and importing it into another file for upload. The solution should ensure accuracy during validation and streamline the workflow. Ideal skills include advanced Excel expertise, VBA programming, and experience with data validation processes.

I need an expert in Excel to create a macro that automates the process of extracting data from one file, validating it, and importing it into another file for upload. The solution should ensure accuracy during validation and streamline the workflow. Ideal skills include advanced Excel expertise, VBA programming, and experience with data validation processes.

Tengo una aplicación de cálculo de presupuestos desarrollada íntegramente en Microsoft Access y quiero llevarla al siguiente nivel. Necesito: • Nuevas funcionalidades – Informes claros y totalmente personalizables. – Campos matemáticos adicionales que indiquen a qué área o partida pertenecen. • Automatización de tareas repetitivas – Generación automática de reportes para reducir tiempo y errores. • Mantenimiento y calidad – Corrección de los fallos que van apareciendo durante el uso diario. – Código VBA limpio y comentado para facilitar futuras ampliaciones. Cómo trabajo Comparto todas las aclaraciones mediante breves vídeos explicativos (ejemplo: ) y ...

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

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