Visual Basic për Aplikacione Jobs

I need a clean, user-friendly Excel workbook that lets me capture transaction information through a single form and instantly generates clear, printable PDF report from those entries. The focus is squarely on reporting, so the workflow should look like this: PLEASE SEE THE ATTACHED CDA WORKSHEET! 1. Form-based data entry • One intuitive sheet (or VBA UserForm) where I can type the key business details—dates, client, amounts, notes, anything you suggest for solid record-keeping. • Dynamic drop-downs or validations to keep entries consistent. 2. Reporting layer • A report sheet that pulls fresh figures the moment new data is added. I’m open to formulas, structured tables, or VBA—whatever produces a smooth experience and reliable output...

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

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