Visual Basic for Apps Jobs

I manage several spreadsheets every week and the manual copying, cleaning, and summarising is chewing up far too much time. My objective is to fold the entire workflow—data import, transformation, and final reporting—into a single, well-structured workbook driven by VBA. just simple task 2-3 hrs max

Objective: Automate the process of converting exported quote data from our sales/CRM system into a standardized Excel layout for creating showroom price lists. Current Situation: We export quotes from our CRM in a consistent format (XL, CSV, or PDF). The target layout for the price list is always the same in structure but must dynamically adjust in length based on the number of items in the export. Currently, this formatting is done manually, which is time-consuming. Requirements: Develop a solution (Excel macro, VBA script, or small program) that: Imports the exported data (CSV or Excel preferred). Re-formats it into the predefined layout automatically. Adjusts the layout dynamically based on the dataset size. Allows customisation of visual elements, including borders, background colo...

I'm seeking an experienced VBA developer to automate several tasks in Excel. Key Tasks: - Automate data entry processes to minimize manual input. - Streamline data analysis and reporting tasks. - Generate charts and graphs automatically from data. Integration: - Must integrate with other Excel files. Ideal Skills and Experience: - Proficiency in VBA programming. - Strong Excel skills, including advanced functions. - Experience with data automation and integration. - Ability to deliver clean, efficient, and well-documented code. - Attention to detail and problem-solving skills. Please provide examples of previous relevant work.

I'm looking for a skilled freelancer to create a simple macro for LibreOffice Writer that can transform text formatting. The macro should be able to: - Change style of certain given texts - Adjust paragraph alignment - Create a two-column, one-row table and moving text in it Ideal Skills and Experience: - Proficiency in LibreOffice Writer - Experience with macro development - Understanding of text formatting and table creation I will send you a text with the precises insztructions

Requirement: Excel Expert to Build a Costing & Wastage Calculation Software I am looking for an Excel master / advanced Excel developer who can create a complete costing software in Excel. The tool should be clean, automated, user-friendly, and suitable for daily business use. Project Scope I need an Excel-based system that can handle: Material costing Quantity-based cost calculations Automatic wastage % and wastage cost Total cost per item Summary dashboard Editable data tables Auto-calculation using formulas or VBA Easy UI for non-technical users Optional (If you can provide): Dropdown selections Protected sheets with editable fields Macros/VBA for automation Multi-sheet system (Raw Material, Costing, Summary, Quotation) PDF export for costing sheets Deliverables ...

We maintain a library of Microsoft Word templates powered by VBA macros and a couple of custom add-ins. Lately the functionality has started to break down—macros fail partway through their routines. With the new Office 365 upgrade, they are blocked from running. I have attached the files. The whole suite includes several macros, 7 templates and a customized tool bar ribbon. Here’s what I need: • Audit and repair the current templates so they run. • Identify bugs in these macros and identify what needs to be fixed. This job is complete when I can run the macros on my system. But, I will probably want to do a phase 2 that is more extensive to fix the bugs you identified and to complete some other macros. Requirements: -comfortable with VBA, Word object m...

I maintain a library of Microsoft Word templates powered by VBA macros and a couple of custom add-ins. Lately the functionality has started to break down—macros fail partway through their routines and the add-ins no longer hook into the templates the way they once did. Here’s what I need: • Audit and repair the current templates so every macro runs end-to-end without errors. • Debug the add-ins so they load reliably and perform their assigned tasks inside Word. • Debug the ribbon menu A job is complete when each macro runs correctly, and every macro or add-in feature can be clicked through without throwing an error or disabling itself. I work in the latest Microsoft 365 environment, so please be comfortable with VBA, Word object model, and any tooling...

I need a single-workbook Excel solution that lets our in-house print team generate accurate job quotes in minutes. The sheet has to capture every major cost driver—material, labour and overhead—then roll them into a clean “Total Cost” and suggested selling price. Pricing figures will be entered manually, but I want smart alerts that prompt us when any input is older than a preset number of days so our numbers never go stale. Conditional formatting or a lightweight VBA routine is fine, as long as it’s easy for non-technical staff to update the cell values themselves. Core flow I’m picturing: • User selects or types project specs. • Workbook pulls the current material, labour and overhead rates from a dedicated “Price Table” tab. ...

I want a single, interactive Excel workbook that pulls everything about my vendors into one place. All source data already lives in separate Excel files, so the dashboard simply needs to consolidate those sheets—no databases or APIs involved. The finished model should let me monitor vendor performance scores, on-time delivery rates, and overall spend while also flagging contract compliance issues such as missing supplier registrations or off-contract price changes. I’d like quick comparisons of quoted versus invoiced prices and a calendar view of upcoming delivery dates. Visually, the dashboard must combine: • Dynamic charts and graphs for trends and comparisons • Clean tables or pivot grids for detail drill-downs • KPI indicators (traffic-light icons o...

Excel Expert Needed to Modify Packaging Picklist + Label Generator Job Description I need an experienced Excel/VBA expert to modify an existing packaging file used in an operations environment. The file is already 90% complete — it only requires logic adjustments, small automation improvements, and layout changes. Project Requirements 1. Packing Logic Update Modify the picklist so parts are packed by lineup number, in assembly order. Ensure boxes are not mixed between lineups unless below a small threshold (I will explain Logic). Optimize to minimize the number of boxes while keeping lineup integrity. Use VBA to make file lighter! 2. Label Generator Modifications Modify existing Label maker for parts: Order number Area type Lineup number Final model SKU with Barcode Quantity A...

I need a clean, well-documented VBA routine that connects directly to NetSuite’s API from Access, retrieves fresh order details, and then pushes two kinds of updates back into the platform: new tracking numbers on each fulfilled order line and a separate call to update inventory stored in the Access table to NetSuite . Here’s the workflow I want in place: 1. Authentication Module: This is already completed in VBA and will be provided. 2. Pull: download all open sales orders since the last run, capturing internal IDs, SKUs, quantities, and any other fields the tracking step will rely on. 3. Update tracking: for each order that now ships, write the tracking number into the appropriate NetSuite field. 4. Update inventory: post revised on-hand counts so NetSuite reflects what actu...

I need my existing financial data pulled into a single, clean workbook that can project my business performance on an annual basis. All historical numbers are already captured in a series of scattered sheets; they simply need to be migrated, reconciled, and then used as the backbone for a forward-looking model. The finished file must automatically generate: • Revenue forecasts • Expense estimates • Cash-flow projections Please keep the structure intuitive—separate tabs for raw data, assumptions, calculations, and a clear summary dashboard. A template-style design that lets me tweak key drivers (growth rates, margins, tax, etc.) and immediately see the impact on each projection would be ideal. Microsoft Excel is my default tool, though I’m open to Google S...

My Microsoft Access database already generates customer notifications and PDF invoices, but the current Outlook-based routine fails too often. I’d like clean, well-commented VBA that switches the send function over to MailSend’s or other commercial service so every email—text body plus optional attachment—goes out reliably (about 1 000 per month). Gmail and other free services require painful authentication and we are not interested. Here is what I need from you: a self-contained VBA module (or class) that authenticates once to MailSend, Brevo or other reliable Platform and sends single messages, accepts parameters for subject, plain-text body, file path(s) for attachments, and returns any error detail back to my calling code. The routine must work from within a s...

I download 10–15l files every weekday and need the entire handling process taken off my plate. The job is to build a reliable workflow that: • Opens each newly-downloaded workbook, applies the basic formatting and cleanup steps I will supply, then saves it under a naming convention I will also provide. • Drops the renamed files into a fixed network/local folder. • At exactly 12:00 pm Monday through Friday, uploads the whole batch to our destination (SFTP, SharePoint, or another path—we can finalise this together). as of now files are uploading manually individually (browse path)needs to be change in existing code (PHP),as files will be upload from folder automatically.. • Fires a confirmation email once the transfer shows as successful. I’m c...

I need a set of Excel workbooks that handle my company’s financial data from raw import to executive-ready insight. The core sheet must calculate revenue growth automatically, pulling monthly figures, applying the right formulas, and flagging anomalies. A clean line chart should refresh on each update so trends are instantly visible during meetings. Beyond the primary sheet, I want supporting pivot tables that slice revenue by product, region, and channel, all connected with slicers for quick drill-downs. Formatting has to be polished—consistent fonts, color-coded variance indicators, and locked cells where inputs shouldn’t change. To save time each month, a basic VBA macro should handle routine steps: clearing last period’s data, importing the new CSV export,...

I need a VBA script to automate data handling in MS Word. Requirements: - Select multiple rows from a table based on user-defined string input - Create a new Word document with the selected rows - Handle cases where no matching rows are found by showing a message and allowing re-entry of the string Ideal Skills: - Proficient in VBA - Experience with MS Word automation - Ability to create user input prompts

I need a smart Excel workbook that lets me map the journey from an initial trading capital of $10,000 to my target of $100,000. The sheet has to auto-populate four key columns—Date, Starting Capital, Lot Size, and New Balance—while compounding the balance and scaling the lot size upward each time the capital grows. Core requirements • A clean control panel where I can set or change the annual return rate and choose the compounding frequency (annual, quarterly, or monthly) without breaking the formulas. • No periodic top-ups: the model must assume “No additional investments” and rely solely on compounded growth. • Lot-size logic that recalculates itself dynamically each period so I can see at a glance what size I should trade as the account expa...

I download 10–15l files every weekday and need the entire handling process taken off my plate. The job is to build a reliable workflow that: • Opens each newly-downloaded workbook, applies the basic formatting and cleanup steps I will supply, then saves it under a naming convention I will also provide. • Drops the renamed files into a fixed network/local folder. • At exactly 12:00 pm Monday through Friday, uploads the whole batch to our destination (SFTP, SharePoint, or another path—we can finalise this together). as of now files are uploading manually individually (browse path)needs to be change in existing code (PHP),as files will be upload from folder automatically.. • Fires a confirmation email once the transfer shows as successful. I’m c...

I want to streamline several day-to-day actions I perform in NetSuite by driving them through well-structured VBA macros. At the moment everything is handled manually—pulling data down to Excel, cleaning it up, re-uploading CSVs, or chasing the same reports week after week. My goal is to replace that routine with clean, reusable VBA code that speaks fluently with NetSuite (whether through CSV import/export, the SuiteAnalytics ODBC driver, or any other connection method you recommend). Here is what I need from you: • Analyse the steps I currently follow inside NetSuite and the companion spreadsheets. • Design and build VBA procedures that replicate those tasks reliably. • Document each macro clearly so I can tweak parameters or ranges in the future. • Walk ...

read through the "Red Snapper Scenario" at the top of the page. All of this week's assignments focuses on historical Red Snapper Catches for 2015 through 2018 (by Quarter) off the coast of Louisiana. The last four rows of the table are empty as 2019 is what you are going to forecast using the historical data for 2015 through 2018. As you scroll down through the Spreadsheet, you will notice in the far left column, there are five tasks for you to complete this week. Every one of these tasks is mirrored in the three YouTube videos below. Although this project is about Red Snapper Catches (your faithful designer's favorite fish to catch and eat out of the southern bays of Louisiana) and the videos forecast Car sales, the process for forecasting the future year (in our case ...

Necesito que construyas una macro en VBA dentro de mi libro de Excel que lea información contenida en celdas específicas y, con esos valores (números, texto y fechas), cree un archivo .txt exactamente con el layout que usa CONTPAQi para la carga masiva de pólizas. Te entregaré un ejemplo de salida ya validado por el sistema; tu código debe replicar ese formato carácter por carácter (encabezados, separadores, longitud de campos, saltos de línea, etc.). Flujo esperado: • El usuario presiona un botón o ejecuta una rutina. • La macro toma los datos de las celdas indicadas y los convierte al tipo y longitud requeridos. • Se genera el .txt en la carpeta y con el nombre que el usuario defina, listo para...