Visual Basic untuk Aplikasi Jobs

Looking for an experienced freelancer to build a formula-based Excel (.xlsx) tool that generates EDIG@S EDIFACT NOMINT messages for gas nominations. Requirements • Generate NOMINT messages (single & multi-point) • Correct EDIG@S segments: UNH, BGM, DTM, NAD, SEQ, LOC, QTY, RFF (opt), UNT • Automatic and correct UNT segment count • Excel formulas only for all EDIG@S logic (no VBA for message generation) • Optional VBA only to export the generated text to a .edi file • Clean input/output separation, ops-friendly Nice to have • Read-only viewing of CONTRL / APERAK • Simple ALLOC generation (daily only) Deliverables • Excel file + brief instructions • Sample NOMINT output MUST HAVE SKILLS • Hands-on EDIFACT / EDIG@S expe...

I have an Excel sheet that already contains options prices, futures prices and strike prices laid out in raw tables. I need a second workbook (or a re-structured copy of the same one) that automatically recognises the at-the-money (ATM) strike, computes the corresponding straddle value, and shows the ratio of that straddle to the current futures price. The file should refresh these three metrics instantly whenever I paste new daily data. The layout I have in mind is simple: source data on one tab, clean summary on another. Formulas are fine; a small VBA routine or Power Query step is welcome if it keeps the workbook fast and eliminates manual intervention. Deliverables • A working .xlsx file with clearly labelled input and output areas • Built-in calculations for:  1...

I need a clean, fool-proof Excel workbook that lets me roster my team by simply typing each person’s start and finish times for every shift. As soon as I enter those times, the sheet must calculate the exact hours worked that day and keep a running total for the week, all without any extra clicks or macros. What has to be captured • Start time and end time for every shift • Hours worked, calculated automatically • A live weekly total for each team member Core requirements • Manual time entry—plain cells where I can type or paste times. • Formulas only (no VBA), compatible with Office 365 and standard desktop Excel. • Clear, protected formula areas so no one overwrites the logic by mistake. • Straightforward layout I can duplica...

I need help to efficiently pair PO numbers with accounts in Excel. Currently, I do this manually using Excel functions, and I'm looking for a more effective solution. Key Tasks: - Analyze current manual process - Develop a streamlined method, potentially using Excel functions, VBA, or other tools Ideal Skills: - Proficiency in Excel, including advanced functions and VBA - Experience in process optimization - Attention to detail and problem-solving skills Looking for a solution that saves time and reduces manual effort.

I have a contacts worksheet in Google Sheet for Mac that often contains more than one row with the same email address. What I need is a lightweight macro I can trigger from a button or shortcut that will: • scan the sheet, • find every email that appears more than once, and • highlight each duplicated entry in red—nothing is to be deleted automatically. The highlight-only approach lets me decide, on a case-by-case basis, which full contact row to keep and which to remove. Aside from the red fill on duplicates, the script must leave every other part of the workbook untouched. Please deliver a ready-to-use VBA module (or an entire macro-enabled workbook if you prefer) that works smoothly in current Mac Google Sheets, along with a short set of installation and usag...

My workbook already contains a sizable VBA routine that keeps our day-to-day data flowing, yet it now throws occasional errors, runs slower than it should, and is missing a few purpose-built functions that would save even more time. I need the codebase tuned rather than rebuilt: squash the bugs, streamline the logic so it executes faster, and insert several new user-defined functions that handle repetitive steps I still perform manually. You will receive the current file with full source code and a short list of the extra tasks these new functions must cover. Please keep the structure familiar, add clear comments, and avoid breaking existing naming conventions so future tweaks remain simple. Deliverables • Clean, fully tested VBA module(s) with all errors resolved • Perform...

Project Description for Excel Expert ​Project Goal: I am looking for an Excel Expert to help me organize and automate my data effectively. ​Data Cleaning: The freelancer must clean raw data, remove duplicates, and fix formatting issues. ​Advanced Formulas: Expert knowledge of formulas like VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH is required. ​Pivot Tables: Ability to create dynamic Pivot Tables and Charts for data summarization. ​Automation (VBA/Macros): I need someone who can create Macros or use VBA to automate repetitive tasks. ​Dashboard Creation: Looking for a clean and professional interactive dashboard to visualize key metrics. ​Data Accuracy: High attention to detail is a must to ensure 100% accuracy in calculations. ​Data Validation: Setting up drop-down lists and data validati...

I need a solid, one-week turnaround on a VBA solution inside Microsoft Access that links our on-premise Horizon MRP Plus database to the cloud-hosted Easy System platform (). The goal is full invoice-data automation: pull the records from Horizon, transform them to the JSON schema required by Easy System, then push and retrieve them through an SFTP endpoint. All work happens inside an existing Access front-end—tables, queries, and forms are already in place, and I can share the current VBA modules that handle local processing. What is missing is the external hand-off and the return feed, plus robust logging so accounting can see exactly what went out and what came back. Key points you’ll tackle: • Write or extend VBA routines that assemble invoice headers, line items, an...

I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • Action: word-for-word replacement (this is a data-processing task, not data entry or extraction). • Source list: multiple columns on a single sheet; assume column A holds the words to find and column B the words to insert. • Scope: apply changes to every cell in every sheet unless I later flag specific sheets to ex...

I’m building a streamlined payroll workbook in Excel that handles everything in one place—from manual attendance entry right through to the final net-pay figure. The file must automatically calculate basic salary, overtime, incentives, standard and optional deductions (PF, ESI, TDS), then roll these up into clear per-employee and month-end summaries. Key expectations • Robust formulas or VBA (your call) that protect against common data-entry errors and flag them instantly. • A clean, intuitive attendance tab designed for manual input; once entries are made, every other sheet should update without further touch-points. • Consolidated reports that let me see totals, breakdowns and variances at a glance. Deliverables 1. Finished Excel workbook with all...

Excel Macro Conversion & Redesign (Windows → Mac / Excel or Numbers) I am looking for an experienced Excel expert to adapt an existing Excel file with macros, originally built on Windows, so it can be used seamlessly on Mac or alternatively converted to Apple Numbers, while preserving full functionality. Scope of work: • Adapt or rewrite Excel VBA macros so they work perfectly on Mac Excel, or provide a reliable solution using Apple Numbers • Ensure all formulas, calculations, and automated processes work exactly as intended • Optimize performance and stability across platforms • Redesign the layout to make the document more modern, visually appealing, and user-friendly • Maintain and properly integrate existing images, charts, and formatting Proje...

I need a streamlined way to record every inward and outward movement of stock so that my running balance is always accurate. The only details I want captured are the product name and its quantity; anything more slows my team down. My preference is to work in MS Excel because everyone here already uses it daily, yet the final sheet must be formatted so it can feed data into our existing custom billing software that issues GST invoices and e-way bills for wholesale orders. A clean CSV export or a lightweight macro that pushes the figures across will do the job—whichever you feel is the quickest to maintain. Deliverables • A ready-to-use Excel workbook with clearly separated inward, outward, and live-stock sheets, plus built-in checks that flag negative or mismatched quanti...

I need my Excel workbook opened up so I can finally see and edit everything inside it. The file is currently locked at the workbook level and its VBA project is also password-protected. I don’t need you to alter, optimise, or add any macros—just remove the protection cleanly, preserve the existing code and data exactly as they are, and send the unlocked version back to me. Deliverable: one fully accessible workbook with all workbook and VBA passwords completely removed, ready for me to work on without any prompts.

Silakan Daftar atau Login tuntuk melihat rincian.

I maintain a growing warehouse spreadsheet and would like to turn the repetitive “copy-paste-filter” routine into a single-click solution. The job is straightforward: write an advanced VBA macro that reads raw inventory data from one or several worksheets and automatically produces a clean, ready-to-share inventory report each time I run it.

I maintain a growing warehouse spreadsheet and would like to turn the repetitive “copy-paste-filter” routine into a single-click solution. The job is straightforward: write an advanced VBA macro that reads raw inventory data from one or several worksheets and automatically produces a clean, ready-to-share inventory report each time I run it. Core expectations • The macro must live inside the workbook, run in modern Windows desktop Excel (2016 or newer), and finish in seconds even with thousands of rows. • Its output should appear on a dedicated, neatly formatted sheet (or export to PDF if easier) with formulas converted to values so the report stays static once generated. • I want to be able to adjust basic parameters myself later—date ranges, column...

I have an existing Excel workbook that is eating up too much of my day with repetitive, rule-based actions. I’m looking for a seasoned VBA developer who can step in, study the workflow, and turn those clicks and copy-pastes into slick, reliable macros. Here’s the big picture: every run of the workbook follows the same pattern—open data sheets, apply a standard set of transformations, push results to summary tabs, and save an updated file for distribution. Right now I’m doing it manually; after your work, I want to press a single button (or trigger a Workbook_Open event) and watch it complete itself. What I’ll share once we get started: • A sample file with dummy data that mirrors the live workbook • A written walkthrough of the current manual ste...