Visual Basic Jobs

Dispongo de una base de datos con: • datos históricos de nóminas • datos de contratación • datos de productividad Quiero consolidarlos en una hoja de cálculo que, por un lado, calcule las nóminas de forma automática y, por otro, genere un análisis predictivo que anticipe costes salariales y posibles variaciones mensuales. Lo que necesito: 1. Plantilla de nóminas – Cálculo íntegro de sueldos, deducciones y aportaciones por empleado. – Fórmulas o macros que minimicen el trabajo manual y eliminen errores. 2. Módulo de análisis predictivo – Proyecciones de 3-6 meses basadas en los tres conjuntos de datos. – Gráficos y paneles c...

I’d like to streamline several day-to-day actions on my Android phone through Macrodroid, but I need an expert to translate my ideas into reliable, battery-friendly macros. I already have a rough outline of the behaviours I want—think automatic toggling of radios, contextual notifications, and scheduled tasks—yet I’m open to your suggestions on the best mix of triggers, constraints, and actions. You should be fully comfortable with: • Building complex macros that combine multiple triggers, conditions, and variables • Troubleshooting loops, conflicts, and permission hurdles on both rooted and non-rooted devices • Exporting finished macros (.macro file) and providing a brief usage guide so I can tweak things later Once we’ve agreed on the ...

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain and occasionally return incorrect results. I need a quick but precise overhaul: • Audit the existing nested IF formulas and pinpoint why certain outputs are wrong. • Restructure the logic—whether that means cleaner IF/IFS statements, a lookup-based approach, or another elegant solution—so it remains accurate and easy to edit later. • Deliver the updated workbook plus a brief, in-sheet note explaining the new logic. No dashboards or macros are necessary right now; I simply want dependable, streamlined formulas that work with standard Excel (Microsoft 365 / Excel 2019). If you are comfortable dissecting...

I have two price lists—each from a different company—that cover identical medical test names. I need one clean Excel workbook that instantly shows which company is cheaper for every test. Here’s what I’m after: • A simple, easy-to-read layout you design for me (I don’t have a template). • Side-by-side columns: Company A price, Company B price, plus an automatic price-difference column. • VLOOKUP, XLOOKUP, or INDEX-MATCH formulas so the sheet updates correctly when I paste in fresh price lists. • Basic conditional formatting that highlights the lower price at a glance. The final file should be ready for me to drop in updated lists without breaking anything, and all formulas must be visible and editable—no hidden code or macros.

I run a wedding & events music agency called XO Sounds. Each week I reformat detailed client booking briefs into simple, tidy artist briefs for our performers. The client briefs have long questions like: "What time can the artists access the venue?" ; the artist version just needs: "Access time". I want a Keyboard Maestro macro (Mac only) that does this automatically, so I can copy a client brief, hit one shortcut, and instantly paste the clean artist version. WHAT THE MACRO SHOULD DO: - Read clipboard text (the copied client brief). - Replace long questions with short labels using a mapping list I’ll supply. - Format the output neatly, including: bold labels, clear section headings, consistent spacing and divider lines. - Apply consistent text styling ...

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain and occasionally return incorrect results. I need a quick but precise overhaul: • Audit the existing nested IF formulas and pinpoint why certain outputs are wrong. • Restructure the logic—whether that means cleaner IF/IFS statements, a lookup-based approach, or another elegant solution—so it remains accurate and easy to edit later. • Deliver the updated workbook plus a brief, in-sheet note explaining the new logic. No dashboards or macros are necessary right now; I simply want dependable, streamlined formulas that work with standard Excel (Microsoft 365 / Excel 2019). If you are comfortable dissecting...

Around 500 text–only records need to be lifted from a series of PDF and image files and entered into Excel with absolute fidelity. Every character must match the source; typos or skipped lines will derail the project. I need the sheet ready in 48 hours, so speed matters, but accuracy matters more. Because a predefined workbook is not available, the first step is to create a clear, well-labeled template that mirrors the logical flow of the originals. Once I confirm the layout, populate the remaining rows and run a final spell-check/pass for consistency. Standard MS Office tools are perfectly fine. Deliverables • Custom Excel template (xlsx) approved before full data load • Fully populated workbook with ~500 rows of clean, verified text • Spot-check summary or ...

We’re seeking an experienced Excel developer to build a Scope 1 and 2 greenhouse gas (GHG) emissions calculator compliant with the GHG Protocol. All IP will be owned by us under a “work-for-hire” arrangement. Work is to be completed by 14/11/2025. Project Overview Build a modular, plug-and-play emissions calculator and dashboard that uses freely available Australian GHG emission factors 1. Capture Scope 1 (fuel combustion, refrigerants) and Scope 2 (electricity) data, perform automated calculations, and visualise results. 2. Ensure data entry is intuitive, calculations are robust, and the dashboard is professional and easy to maintain. Key Features & Page Breakdown 1. Front-End Dashboard & Summary – High-level KPIs: annual/quarterly Scope 1, Scope 2, and t...

I need a clean, easy-to-update Excel sheet that lets me record day-to-day employee attendance and, most importantly, capture every instance of unpaid leave. The file should: • Display a calendar-style grid for the month where I simply type or select “U” (or similar) to flag an unpaid day off. • Roll those marks into running monthly and year-to-date counts, so I always see how many unpaid days each person has taken. • Highlight employees who exceed a threshold I can change in one cell. • Produce a quick summary tab showing totals per employee and an overall team snapshot. A few usability touches would be great—drop-downs for status, clear colour coding, and formulas locked to avoid accidental edits—but keep the workbook lightweight so anyo...

I have a worksheet that I update frequently and I’d like a single, easy-to-run VBA macro that tidies everything up for me in one click. Here’s what the macro must do, in the exact order listed: • Turn the entire header row blue so it stands out. • Alphabetically sort all rows A-to-Z (no special multi-key sorting; a simple full-sheet sort is fine). • Locate every weight field currently stored in kilograms, multiply the values to convert them to pounds, and rename the corresponding header to “Lbs.” • Format Column AC as Accounting so all monetary figures align cleanly. • Finally, read Column A, split the data by client name, and save each client’s records to its own workbook (file names can follow the client name). A straightfo...

I own an eight-unit property and I’m looking for a streamlined spreadsheet—built in either Microsoft Excel or Google Sheets—that lets me see, at a glance, how each unit and the building as a whole are performing month by month. Income I track today is limited to rent payments plus any miscellaneous money that comes in (think laundry revenue, parking, etc.). On the expense side I need clear buckets for maintenance costs, utilities, and the fees I pay my property manager. The sheet has to handle both levels of detail: • an individual tab (or clearly separated section) that shows cash-flow for each of the eight units, and • an automatic roll-up that aggregates everything so I can view overall property performance without extra work. Key features I’m ...

I need my existing sheep breeding data moved into a clean, user-friendly Excel workbook. Each row should represent one individual sheep, with columns for: • Birth date • Sire and dam (lineage) • Weight and growth statistics (initial weight, periodic weights, gain calculations) Please reformat the current sheet so headers are clear, data types are consistent, and empty cells are filled where information is available. Simple formulas that auto-calculate age, average daily gain, and any missing growth metrics will help me track performance at a glance. A tidy summary sheet that pulls key figures—such as fastest growers or average weights by birth month—would be a bonus, provided it stays lightweight and easy to maintain. When you’re done, I want to be ...

I have two Excel workbooks that hold policy information for 2025–2026. I only need the premium amounts pulled out, merged, and summarised in a single pivot table that lets me quickly: • filter by underwriter name • switch between expired and active policies • show only rows where premium is greater than €5,000 Keep the solution simple and self-contained—an updated workbook with the pivot already in place is perfect. If a short VBA macro or Power Query step is the fastest route, feel free to use it, but I should be able to open the file and refresh the pivot without extra setup. Also find innovative ways to simplify the work and present it in a clear and nice way

I’m looking for an experienced Excel professional who can step in and solve a variety of spreadsheet challenges as they arise. Typical requests may include tightening up existing formulas, setting up new sheets for reporting, cleaning or re-structuring data, automating repetitive tasks with macros or Power Query, and presenting results in clear, well-designed charts or dashboards—whatever will help me move faster and make better-informed decisions. Because my needs can shift from week to week, I value someone who communicates clearly, asks the right clarifying questions, and can deliver polished, error-free work on short notice. If you’re comfortable tackling both small tweaks and more involved projects, please let me know your availability, estimated turnaround times, a...

I’m looking for a developer who can turn my day-to-day paperwork into a click-and-print process. The core need is a system that lets me enter order information once and instantly create: • Commercial invoices (primary use) • Matching packing lists • Embark/shipping labels Key requirements • Export options: every document must download or print in both PDF and Excel. • No automated math: taxes, discounts, or any extras are entered manually—just capture and display what I type. • Clean, professional templates that keep the same layout regardless of the volume of line items. • Simple record management so I can retrieve, edit, or duplicate previous shipments instead of re-typing everything. Scope of work 1. Build the data-entr...

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain and occasionally return incorrect results. I need a quick but precise overhaul: • Audit the existing nested IF formulas and pinpoint why certain outputs are wrong. • Restructure the logic—whether that means cleaner IF/IFS statements, a lookup-based approach, or another elegant solution—so it remains accurate and easy to edit later. • Deliver the updated workbook plus a brief, in-sheet note explaining the new logic. No dashboards or macros are necessary right now; I simply want dependable, streamlined formulas that work with standard Excel (Microsoft 365 / Excel 2019). If you are comfortable dissecting...

I have a small batch of information that I need transferred quickly and accurately into a digital format. All source material is ready; it only needs to be copied without errors into the specified fields—primarily simple Excel sheets or an online form. Here’s what I’m looking for: • Fast, error-free typing and careful attention to detail • Familiarity with basic Excel functions (sorting, filtering, simple formulas) or equivalent online form tools • A brief progress update once the first few rows are complete so we can confirm formatting before you continue The dataset is limited, so this should be a short, straightforward task—perfect for someone who can start right away and deliver a clean, finalized file.

This is an ongoing, 30-plus-hour-per-week role building and refining advanced Excel solutions for my business. Every day you will dive into existing workbooks and create new ones that combine solid VBA and macro logic with polished, user-friendly dashboards. Complex data shaping, reusable functions, and tight error trapping are the norm, so deep VBA experience and the ability to script in Python for data preparation or external automation are absolutely essential. Turnaround is fast—I need someone who can log in and start contributing today. Typical tasks include automating multi-sheet reporting packs, harvesting data through Python scripts, and transforming raw inputs into clear, interactive models that decision-makers can explore without touching code. While Excel is home base, t...

I need an organized self-starter to key large batches of brand-new information into Excel with speed and precision. The task centres entirely on entering new data; nothing is being reorganised or analysed at this stage—just clean, consistent input. Here’s what I expect: • Receive raw records (mostly digital files and the occasional online form export) and enter them into my pre-formatted spreadsheet. • Maintain original field order, naming, and data types. • Spot obvious errors, duplicates, or missing values and flag them in a separate “Issues” tab. • Run basic Excel validation (drop-downs, data-type checks, conditional formatting) before submitting each batch. • Provide a short progress update at the end of every workday. The volu...

Every three months I pull sales figures from several different files, emails, and ad-hoc spreadsheets. I need those numbers placed into my standard Excel template so the final report is clean, consistent, and ready to share with management. Here’s what I will hand over: • My locked-in Excel template for the report layout • All raw figures in the form of CSVs, screenshots, or simple lists—whatever format the sources come in for that quarter What I need from you: • Enter the data accurately into the correct cells and tabs • Apply any built-in formulas already present in the template and check that totals, percentages, and charts update correctly • Give the file a quick once-over for spelling, date ranges, and obvious anomalies before sending it ...

Hello, I have read your project details carefully and fully understand what you need. You want to fix and simplify complex nested IF formulas in Excel so that the logic becomes accurate, easy to edit, and error-free. ✅ I can: Audit your existing formulas and identify where the logic is breaking. Simplify them using IFS or LOOKUP-based methods (depending on your Excel version). Deliver a clean, well-documented file with an in-sheet explanation note. I have strong experience in Excel formula optimization, logic restructuring, and data validation. You will get a neat, efficient solution that works perfectly in Microsoft 365 or Excel 2019. Let’s discuss your workbook and start fixing it right away! Budget: Flexible within your mentioned range. Delivery: Within 1 day (depending on ...

I need a clean, easy-to-update Excel sheet that lets me record day-to-day employee attendance and, most importantly, capture every instance of unpaid leave. The file should: • Display a calendar-style grid for the month where I simply type or select “U” (or similar) to flag an unpaid day off. • Roll those marks into running monthly and year-to-date counts, so I always see how many unpaid days each person has taken. • Highlight employees who exceed a threshold I can change in one cell. • Produce a quick summary tab showing totals per employee and an overall team snapshot. A few usability touches would be great—drop-downs for status, clear colour coding, and formulas locked to avoid accidental edits—but keep the workbook lightweight so anyo...

I have a growing stream of sales transactions coming in daily and I want one well-structured Excel workbook that takes me from raw import all the way to polished reports and ready-to-send invoices. The core of the job is data entry and processing, so I’ll hand you CSV dumps from the POS; you’ll build a routine that pulls them in, cleans the fields, and organizes everything on a master sheet without manual touch-ups. Once the data flows correctly, I need dynamic sales reports—pivot tables, charts, whatever makes trend analysis quick—plus a template that can generate individual customer invoices automatically. If a bit of VBA or Power Query makes the workflow smoother, go for it; the file just has to stay easy for non-technical staff to update. Deliverables • I...

Preciso de uma planilha de controle de estoque que simplifique meu dia a dia. Quero registrar entradas, saídas e saldo atual de cada item em um único local, com fórmulas que atualizem tudo automaticamente. O ponto-chave é contar com relatórios de vendas apresentados em tabelas claras, para que eu possa filtrar períodos, produtos e visualizar rapidamente o desempenho. Se desejar, você pode incluir filtros dinâmicos ou tabelas-dinâmicas, contanto que o resultado permaneça intuitivo. Aceito a solução em Excel ou Google Sheets. Caso prefira automatizar algo com VBA ou Apps Script, fique à vontade, desde que o uso permaneça simples para quem não programa. Entrego os dados brutos; preciso ...

We’re seeking an experienced Excel developer to build a Scope 1 and 2 greenhouse gas (GHG) emissions calculator compliant with the GHG Protocol. All IP will be owned by us under a “work-for-hire” arrangement. Work is to be completed by 14/11/2025. Project Overview Build a modular, plug-and-play emissions calculator and dashboard that uses freely available Australian GHG emission factors 1. Capture Scope 1 (fuel combustion, refrigerants) and Scope 2 (electricity) data, perform automated calculations, and visualise results. 2. Ensure data entry is intuitive, calculations are robust, and the dashboard is professional and easy to maintain. Key Features & Page Breakdown 1. Front-End Dashboard & Summary – High-level KPIs: annual/quarterly Scope 1, Scope 2, and t...

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain and occasionally return incorrect results. I need a quick but precise overhaul: • Audit the existing nested IF formulas and pinpoint why certain outputs are wrong. • Restructure the logic—whether that means cleaner IF/IFS statements, a lookup-based approach, or another elegant solution—so it remains accurate and easy to edit later. • Deliver the updated workbook plus a brief, in-sheet note explaining the new logic. No dashboards or macros are necessary right now; I simply want dependable, streamlined formulas that work with standard Excel (Microsoft 365 / Excel 2019). If you are comfortable dissecting...

I need mixed text-and-number records copied from several online databases into a clean spreadsheet template that I’ll share with you at kickoff. Your task is straightforward yet detail-oriented: locate each record, pull every required field, and paste it into the correct column while keeping original spelling, punctuation, and numerical precision intact. Please follow the header structure in the template and apply consistent formatting (dates as DD/MM/YYYY, currency without symbols, etc.). Along the way, double-check for missing values or obvious inconsistencies and note anything that looks questionable. When the sheet is complete, give it a quick sort/filters test so I can immediately work with it. Deliverables • A fully populated spreadsheet, free of blank mandatory f...

I need a detail-oriented freelancer to handle our data olahan and keep it impeccably organized in Microsoft Excel. What you’ll do • Enter, clean, and structure the data so everything is consistent and searchable. • Double-check figures for accuracy and spot any anomalies before they become issues. • Maintain strict confidentiality at every step. What I’m looking for • Strong, proven experience in data entry—please highlight your pengalaman in your bid. • Solid mastery of Excel functions such as filters, pivot tables, and data-validation rules. • A commitment to fast but error-free turnaround. The finished deliverable will be an up-to-date, clearly labeled Excel workbook ready for immediate use in our internal systems.

I’m consolidating several moving pieces—customer invoices, contractor costs, and cash-flow timing—into one well-structured file built in either Excel or Google Sheets. The core of the job is to design formulas, linked tables, and a clear visual dashboard that lets me: • Enter or import each customer invoice (name, issue date, amount) and instantly see the running total outstanding. • Record every contractor’s billing rate, actual pay rate, and any monthly expenses so I can compare gross margin at a glance. • Display our bi-weekly payment schedule as an easy-to-read graph that highlights upcoming inflows and flags potential shortfalls. From those inputs I want automated calculations that surface cash shortages, margins by customer and by contra...

I’m looking for a sharp eye to go through one straightforward Excel workbook that tracks all Accounts Payable entries from 2023 up to the present. The goal is simple: spot every error that slipped in and put things right so the file balances perfectly. The ledger has a few small sections that need to be broken out in addition to the full total owed. The issue is when each section is sectioned out and added together which should be the same as the full total, they are not the same numbers. Here’s what I need: • Scan the entire sheet, isolate discrepancies, duplicates, mis-postings, or missing entries. • Correct each issue directly in the workbook and clearly highlight the change. • Provide a short summary tab listing every correction with a brief note on wh...

Project Overview: I’m seeking an experienced developer or team with strong skills in AI, market data integration, and web development to build a private trading intelligence dashboard similar in concept to MRKTEDGE.AI. The platform’s core function is to generate high-quality trade ideas by combining technical analysis, fundamental data, and macroeconomic sentiment. It should process real-time market inputs to identify confluences, directional bias, and technical entry levels—then output actionable trade setups with targets, stops, and narrative reasoning. ⸻ Core Objectives • Develop a private dashboard (not public) with AI-driven trade generation. • Integrate live macro, sentiment, and technical data. • Generate and display automated trade ideas with ...

I need a straightforward CSV file built in Microsoft Excel that I can later import into other systems. The file should be ready-to-use and include these columns: • Customer Name • Email Each contact detail must sit in its own column—no combined fields or comma-separated strings. A clean header row and basic data validation (e.g., text format for phone and email) will help me avoid future import errors. Deliverable: an Excel workbook saved as a CSV (UTF-8) plus the original .xlsx version in case I need to edit the structure later. No data entry is required; I only need the correctly formatted template. The data needs to be aggregated from these two websites: 1. 2. (need everyone A-Z) Thank you!

I need an expert in Excel or Google Sheets to create a simple and automated file to manage my fruits and vegetables business. The file should include a main dashboard, customer sheets, and an invoice system — all linked and easy to use. Main Features: Dashboard showing total sales, payments, and balances Individual sheets for each customer with daily entries Automatic balance carry forward Printable A5 invoice that fills automatically by customer or date Support for daily, weekly, or monthly billing Should work smoothly in both Excel and Google Sheets (no macros, only formulas) Goal: To make my business records easy to update, track, and print invoices anytime from Excel or Google Sheets.

I need a person who can extract text and matched cell number manually from excel files.

I have a collection of digital spreadsheets containing purely numeric fields that need to be transferred into a single, well-organized master file. The source documents will be supplied in their original formats (mostly .xlsx or .csv); I simply need every number moved across accurately, checked for obvious errors, and aligned with the column structure I will share. What you will do • Open each supplied sheet, copy the numeric data, and paste or import it into the master template I provide. • Ensure totals, decimals, and any date-related figures remain intact and precise. • Flag any missing or suspicious values so I can review them quickly. • Deliver the completed master file plus a short log of issues you found (if any). No text entry, formulas, or complex cleanup is ...

I have several Excel spreadsheets that contain a mix of text and numerical fields, and I need every line transferred by hand into a clean, consolidated sheet. This is strictly manual data entry—no scraping tools or macros—so accuracy is essential. You’ll receive the source workbooks plus a target template; simply copy each value exactly as it appears, double-check figures, and keep text capitalization and punctuation intact. Deliverable • A single, fully populated spreadsheet that mirrors the source data without omissions or typos, ready for immediate use.

I need a well-structured Excel workbook that consolidates our monthly Sales data and Marketing analytics into a single, easy-to-refresh reporting table. The focus is on clarity and repeatability rather than flashy visuals, so I’m looking for neatly formatted summary tables that management can review at a glance. Scope • Import or link two data sources—Sales and Marketing—into a clean data sheet (Power Query or another approach you prefer). • Build dynamic named ranges or structured tables so I can drop in each month’s data without breaking formulas. • Create a summary sheet that automatically aggregates the latest month and year-to-date numbers, clearly separating Sales metrics from Marketing KPIs. • Include basic slicers or drop-down filt...

I need an automation expert who has already built AI-powered PDF extraction + Excel auto-population workflows. The goal is to take tender documents (PDF), read the Description field, extract required details, and automatically fill a pre-formatted Excel file (with formulas already built inside), exactly like the sample sheet I have. This process currently takes 4+ hours manually, and I want to fully automate it using n8n + OCR + AI (LLM). What the automation must do Read the Description text from PDF files (one per row or batch) Extract structured fields using OCR + AI model (OpenAI / Google Document AI / AWS Textract) Map extracted data into specific input columns (red columns) in Excel template Let Excel formulas auto-calculate the remaining columns Output a completed Excel file (s...

We have 2 reports one from the payment provider and one from the in house system we need to match and find differences. The only unique identifier is the amount. I need a formula that will match them off and highlight transactions missing. So I can dump the 2 reports in daily and it spits out the difference on a summary tab. Would be best if can be done without VBA if possible. Each report is only about 100 lines per day

I need fresh, persuasive blog posts that nudge readers toward a purchase. Each article will live on my website and be repurposed in shorter form on social media, so the tone must stay consistent while adapting smoothly to both spaces. Here’s what I’m after: • Compelling headlines, introductions, and clear calls-to-action that focus on increasing sales • Light keyword integration for basic on-page SEO (no deep-dive audits required) • A concise social caption or teaser pulled from the main post I’ll provide product details, audience insights, and any brand notes up front. You’ll return a clean draft ready for quick publishing; I’ll handle final formatting once approved. If we click, there’s room for ongoing work, but for now let’...

I’m looking for a detail-oriented professional to take charge of my project and technical documentation while keeping all supporting data clean, organized, and analysis-ready. I run multiple civil-engineering jobs and need every drawing log, material register, and progress report captured accurately, then transformed into clear MS Excel files that I can share with stakeholders at a moment’s notice. Key responsibilities • Compile source information from drawings, site notes, and email trails, then structure it into live Excel trackers. • Input new data promptly, flag inconsistencies, and carry out routine data-cleaning so every sheet stays error-free. • Generate weekly and ad-hoc analytical reports—charts, pivot tables, or summaries—that highl...

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain and occasionally return incorrect results. I need a quick but precise overhaul: • Audit the existing nested IF formulas and pinpoint why certain outputs are wrong. • Restructure the logic—whether that means cleaner IF/IFS statements, a lookup-based approach, or another elegant solution—so it remains accurate and easy to edit later. • Deliver the updated workbook plus a brief, in-sheet note explaining the new logic. No dashboards or macros are necessary right now; I simply want dependable, streamlined formulas that work with standard Excel (Microsoft 365 / Excel 2019). If you are comfortable dissecting...

I’m looking for a streamlined upgrade of my existing Excel file so I can produce land-and-building valuation reports quickly, accurately, and in a banker-ready format. Here’s what I need in this first, lightweight version: • Automatic calculations for both land and building values. • A clear depreciation formula that adjusts results based on the building’s age. • A summary sheet that rolls everything up into one total property value. • Professional formatting throughout, branded with my company name and logo. • A single click to print a neatly formatted valuation certificate on A4. • Separate, easy-to-navigate sections (or tabs) for Land Details, Building Details, and Remarks. The current workbook already contains the raw figures...

I have an existing Excel file that tracks several performance metrics, and I’d like to turn it into a self-updating dashboard. The workbook should pull new data into the tables automatically and refresh the related charts without any manual steps. The graphs need to showcase: • Key Performance Indicators (KPIs) • Employee productivity figures • Departmental performance trends Key requirements • Daily refresh: as soon as the source data is updated, every chart must reflect the latest numbers. • Clean, intuitive layout so leadership can spot changes at a glance. • Robust formulas, pivot tables, or Power Query—whatever achieves a reliable, one-click (or zero-click) update. • No broken links or hard-coded ranges; everything sho...

I’m looking for a web-development expert to integrate a fully functional contact form into my existing website. The project is strictly a feature addition—no redesign is needed—so your work should blend seamlessly with the current layout and styling. Here’s what I expect: • A responsive contact form that captures name, email, subject, and message fields, plus any anti-spam measure (reCAPTCHA or similar). • Server-side processing that safely validates and sanitises inputs, then sends the message to my designated email address. • A confirmation/thank-you message for users and an error state for failed submissions. • Clear instructions or light documentation so I can adjust destination email addresses later if necessary. Tech flexibility: ...

I run a catering business where the guest count changes daily, so I need a lightweight accounting package that does more than just track money. The core of the job is simple: let me upload each menu item with its full recipe, then automatically plan the ingredient quantities required for the day based on projected occupancy. Essential features • Recipe upload and editing – ingredients, yields, and cost per portion. • Occupancy-driven planning that converts headcount into exact ingredient quantities. • Automatic shopping list generation, grouped by supplier or category. • Real-time ingredient inventory: deduct on use, alert me when stock falls below set levels, and allow quick adjustments. Nice-to-have but not mandatory: an expenses ledger and basic inc...

I need help fixing a VBA issue in Excel related to calculating a threads loop. The current code has a problem that needs to be resolved. Ideal Skills and Experience: - Proficiency in VBA for Excel - Experience with threading and loops in VBA - Problem-solving skills to diagnose and fix errors

I need a straightforward way to pull both real-time and historical stock prices directly into Microsoft Excel. A lightweight solution is fine—just the essentials that let me: • enter one or more ticker symbols • click (or auto-refresh) to receive up-to-the-second quotes plus past closing data • store the returned values in ordinary worksheet cells for easy charting and analysis I’m open to any reliable API—free tiers such as Alpha Vantage, IEX Cloud, or Yahoo Finance are okay, as long as the key setup steps are included. A simple VBA script, Power Query setup, or worksheet function add-in all work for me; pick whichever gets the job running quickly. Deliverables: 1. An Excel file pre-wired to fetch real-time and historical data. 2. A short setup ...

I want my market-tracking spreadsheet to pull live quotes from AngelOne SmartAPI, update automatically, and display everything in clear, interactive line charts. To get this running smoothly, please start with your own Angel Broking account while you build, test, and refine; once everything works, I’ll use my client ID, MPIN, and TOTP later on switch the connection over. (Angel api is free), you can use an api of your choice also but result needs to be same. Here’s what I expect: • SmartAPI connection wired into Excel, refreshing tick data in real time. • A simple drop-down or slicer that lets me choose among Nifty50, Nifty500, and the full universe of FNO stock futures. I need the flexibility to jump between single symbols or whole indices. • Live line ch...

I have several hundred invoice PDFs sitting in one folder and a companion Excel workbook that already lists data of the above mentionded invoices (including invoice number, supplier name, amounts, dates, etc). What I now need is a small program that will open every PDF, read the key details, and append them as new columns in the same spreadsheet. The data to be captured is: • PDF name • Invoice number • Selling date • Issuance date • Net amount • Gross amount • Supplier name • Full item description Once extracted, amounts and any other figures must be written into Excel as true numeric cells so later calculations work without manual re-formatting. Dates should land in native date format, while text such as supplier and description c...