Excel VBA Jobs

I have a working Python script that reads an XLS sheet, logs in to Zerodha and fires trades; I now need the same workflow adapted for StoxKart. The new script must log in with a session token (no API key flow) and then: • Parse the XLS file row-by-row • Place the corresponding orders in StoxKart • Immediately fetch and record each order’s status so I can reconcile fills in the sheet Please keep the structure clean and modular so I can drop in different brokers later. If you have handled StoxKart’s session-based authentication before, that’s a plus. Deliver the fully-commented .py file along with any helper modules, and include a short README showing startup steps and the format the XLS parser expects.

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 have several spreadsheets that need accurate, timely data entry directly in Microsoft Excel. Your task is to take the raw information I provide—names, numbers, text notes—and record it in the correct columns and rows so everything is clean, consistent, and ready for reporting. The work is strictly data entry rather than analysis, but attention to detail is crucial because these sheets feed into other parts of my workflow. If you are comfortable with standard Excel functions like quick sorting, simple validations, or setting up drop-down lists, that will help keep the files error-free, though no complex formulas are required. I will supply clear instructions, the source files, and a small sample so we can confirm format before you begin the bulk of the job. Accuracy, confide...

We already have an existing Excel sheet used for pre-sales task tracking and leads management, but it requires full restructuring, optimization, and professional dashboard development. The current file includes: Leads and project details Task assignment to pre-sales engineers Due dates, statuses, and weights Basic KPIs (On-Time Rate, Average Time, etc.) However, the file is not structured, contains redundant columns, and lacks a proper dashboard and automation. We are looking for an expert to rebuild this into a professional management tool. Scope of Work: 1. Data Structure Optimization Clean and restructure the current sheet: Remove unnecessary/duplicate columns Separate: Raw data (database) Calculations Dashboard Standardize fields such as: Lead Type System Status Assigned Engineer ...

Διαθέτω έναν βασικό πίνακα Excel όπου καταγράφω το πληθος των ημερομισθίων ανα μηνα, των εργαζομένων μου. Θέλω να μετατρέπεται αυτόματα σε πίνακα παρουσιών ανά ημερομη...

Ich habe 580 Datensätze mit Postleitzahlen und möchte sie in Excel als übersichtliche Punktkarte Blasenkarte auf einer Landkarte darstellen. Aufgabenstellung • In einer einzigen Excel-Datei soll eine Punktkarte entstehen, die alle 580 Standorte korrekt platziert. • Die Punkte sollen entsprechend dem vorgegeben Wert unterschiedlich gross sein. • Die Karte soll sauber formatiert sein, damit sich Cluster und Einzelpunkte klar erkennen lassen (farbliche Abgrenzungen oder dezente Beschriftungen sind willkommen, solange die Lesbarkeit gewahrt bleibt). Damit Sie direkt loslegen können, stelle ich eine Excel-Tabelle mit Spalten für Postleitzahl, Beschreiung und Wert bereit. Bitte nutzen integrierte Excel-Mapping-Funktionen oder Power Map/3D Maps ...

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 need a fully linked Excel model on Autoliv (ALV) built from scratch using the data available in the Investor Relations section of Please pull a minimum of two historical years and project five annual periods forward. All three core statements—Income Statement, Balance Sheet and Cash Flow—must flow together seamlessly. Revenue and cost assumptions should go beyond a high-level view; I want a detailed breakdown that is clearly tied to the best KPIs you can source at the company, industry or macro level (units shipped, ASPs, raw-material indices, safety-system penetration rates, etc.). Add supporting schedules (working capital, capex & depreciation, debt, equity, tax) so each forecast line is transparent and auditable, and include ratio analysis wherever it improves insigh...

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

Need Excel + Power Query Expert for Inventory Dashboard (Pen Drive Based System) Project Overview: I run a manufacturing business and maintain stock in multiple Excel files (7–10 files), each for different categories like motors, inverters, pumps, etc. These files are stored in a folder on a pen drive. I need a simple, reliable system to view consolidated stock in one place without manually opening multiple files. Constraints (VERY IMPORTANT): * All files will remain on a pen drive (no cloud solutions like OneDrive or Google Drive) * Folder path will remain fixed (example: E:Stock_Files) * I will only open ONE master Excel file (no need to open individual files) * System must work offline * Must be simple to use (non-technical staff) Requirements: 1. Use Power Query (“Fr...

I need a comprehensive financial report spreadsheet created in Microsoft Excel. The spreadsheet will need to handle mixed data types, including numbers, text, and descriptions. There already is a financial model, but it needs to be optimised and also be able to be changed into different currencies. There then need to be a consilidation option needed as well. Key Requirements: - Create a detailed financial report - Use Microsoft Excel - Handle mixed data types - Ensure data accuracy and integrity Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience with financial reporting - Attention to detail and accuracy - Ability to manage mixed data types Please provide samples of previous financial reports created in Excel.

I need a single Excel workbook that can serve as an issue register for roughly twenty ongoing projects. Each project will sit on its own sheet, and every sheet must let me log: • the date an issue is booked • its target closure date and actual closure date • a status field with the options Open, In Progress, or Resolved • the name of the resource responsible for that issue Across the whole file I want a compact dashboard, shown as summary tables, that rolls everything up in real time. At a glance I should see: • total issues booked • total issues still open • total issues closed / resolved A simple date-range filter is essential so I can instantly list all deliverables that remain open (or moved to Resolved) between any two dates I choos...

I need a concise list of ultra-short usernames—only two or three characters long—that could realistically be registered or claimed on today’s major social or SaaS platforms. Every name may combine letters and numbers in any order; there is no requirement to start with a letter, end with a number, or follow a fixed pattern. Your task is to research availability, compile the candidates, and deliver them in a simple spreadsheet showing: • the exact username • the platform on which it’s currently available (please check at least the big four: Twitter/X, Instagram, TikTok, and GitHub) • the date/time you verified it I’m interested solely in these ultra-short handles, so skip anything longer than three characters. A clean, well-organized ...

I need a single Excel workbook that lets me monitor four different products from the moment they come into stock until they reach my customers each week. The file must show, at a glance, how many units I still have on hand, how many went out this week, and the exact date each order was placed. The only way I want to add customer orders is through a clean, user-friendly form—no typing directly into tables. When I open the form, I should be able to pick the product, enter the quantity requested, choose or type the customer name, and hit submit. As soon as I do that, the workbook should automatically: • deduct the quantity from the correct product’s stock balance • stamp today’s date (or the date I select) as the order date • log the transaction so w...

I have two nearly identical Excel workbooks—each with approximately 300 rows and columns A through AE—that need to be merged into a single, clean master sheet, which is already established. The goal is to streamline our data management by ensuring every record is transferred accurately and all duplicates are eliminated using an automated duplicate-checking tool, rather than manual review. The finished file must reach me by Wednesday, 16 April 2026, midday AET.

I need a clean, branded Excel file that lets me build product-only quotations quickly while still looking fully professional to my clients. The sheet has to show, at minimum, columns for Product Name, Product Description, Quantity and Unit Price, with automatic line totals, subtotal, tax and grand total calculations. I sometimes attach images to help the client visualise an item, so please leave space or an optional column that can accept embedded pictures without breaking the layout. A few other things will make the file truly useful to me: my company header and contact block locked into place, space for the client’s details, auto-generated quotation number and date, clearly formatted terms & conditions at the bottom, and colour-coded cells so it’s obvious which fields I ...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

I am looking to develop a professional Excel-based system to manage and track daily, weekly, and monthly tasks across multiple departments within our company. Departments include: - Human Resources - Finance - Logistics - Projects - Administration The system should be user-friendly and designed to support management-level monitoring and decision-making. Key Requirements: 1. Main Dashboard: - Total number of tasks - Completed tasks - Delayed tasks - Tasks in progress - Task distribution by department - Completion rate per department 2. Central Task Input Sheet: Should include the following fields: - Department name - Task title - Short description - Assigned person - Start date - End date - Priority (High / Medium / Low) - Status (Not Started / In Progress / Completed / Delayed / On Ho...

I need help getting my Excel macros to work. They don't run at all, and I haven't changed my Excel version or disabled macros. Ideal skills and experience: - Expertise in Excel and VBA - Experience troubleshooting Excel macros - Ability to work on older Excel versions

I have a collection of Excel sheets filled with raw numbers that need to be brought up to date, checked for accuracy, and turned into something I can actually use for decision-making. Your first task is straightforward numeric data entry: complete any missing figures and confirm existing totals with simple cross-checks so everything balances. Once the numbers are rock-solid, I’d like you to move straight into data analysis inside the same workbook—think pivot tables, descriptive statistics, and clear charts that highlight key trends. Please keep all work native to Excel (Office 365 or compatible) and avoid external add-ins so the file remains easy for me to open and audit. Deliverables: • Updated workbook with verified numeric entries • Separate analysis sheet c...

Build a reusable, branded one-page ROI summary in Excel for a plate funding sales tool. The template must auto-calculate all outputs from a small set of input cells, be formatted with the client's logo and brand colours, and produce a clean customer-facing layout that a sales team can use per deal without any Excel knowledge.

Détails du projet Descriptif de la mission : Création d'un Tableau de Bord de Gestion Financière sur Excel Objectif : Concevoir un fichier Excel automatisé, professionnel et visuellement attrayant pour le suivi des recettes et des dépenses, avec mise à jour en temps réel des soldes et des graphiques. 1. Structure du fichier : Le document doit comporter au minimum trois onglets distincts : Configuration : Pour lister les catégories de revenus et de dépenses (ex: Salaire, Ventes, Loyer, Fournitures, etc.). Saisie des données : Un tableau propre pour enregistrer chaque transaction (Date, Description, Catégorie, Type [Recette/Dépense], Montant). Tableau de bord (Dashboard) : Une page de synthèse v...

I need an advanced Excel expert to assist with a independent capstone project. The project requires proficiency in: - VBA, Macros, Formulas, and Functions - Data Visualization, specifically Bar Graphs - Creating Custom Functions Ideal skills and experience would include: - Advanced knowledge of Excel and its functions - Experience in automating tasks using VBA and Macros - Strong data visualization skills, particularly with bar graphs - Ability to create custom functions to meet specific project needs Please provide examples of similar work done.

I have a collection of CSV and native Excel files that need to be merged into one clean, well-structured workbook. The source material already sits in digital form, so no manual transcription from scans is required—just careful extraction and organization of the mixed data (both numbers and text). Here’s what I need from you: • Import each CSV/Excel source, preserving every value exactly as it appears. • Standardize column headers and align the datasets into a single master sheet (or a set of logically separated tabs if that proves clearer). • Run quick checks—basic formulas, filters, or conditional formatting—so obvious discrepancies or mis-typed entries surface immediately. • Deliver the final .xlsx file plus a brief note summarizing an...

I have an existing Excel file that lists product quotations, but its layout is messy and makes quick pricing reviews difficult. I need it turned into a clear, professional template—with tidy column headers, consistent currency and percentage formatting, built-in totals, and space for my logo and client details—all by tomorrow. You will receive the current workbook plus a short style guide. Please keep every price and SKU exactly as they are while improving readability and adding any formulas needed for automatic subtotals, taxes, and grand totals. When finished, send back the polished .xlsx and a ready-to-print PDF version. Acceptance criteria • No data loss or price changes • Formulas work when I add new rows • Headings, fonts, and cell styles match the ...

I’ve built our social-media content calendar in Excel and now need a clear, scroll-friendly timeline inside the same file. The goal is to glance at the sheet and instantly see which posts are scheduled, which channel or format they belong to, and how they line up across the coming days. Here is what I need you to deliver: • Insert an in-sheet timeline (think lightweight Gantt) that automatically pulls from the existing rows. • Display two data points on every bar: the scheduled post date and its content type (e.g., Reel, Story, Blog-link). • Keep it dynamic—when we add or shift a row, the visual updates without extra steps. The workbook is already structured; you can add helper columns, named ranges, or PivotCharts if that speeds things up, but please a...

I have the numbers but need them organized into a clear, reliable annual budgeting model in Excel. The file should let me input or update assumptions quickly while flowing those changes through to projected revenues, expenses, and ending cash balances for the full year. Key things I am looking for: • Solid financial-modeling technique—clean, auditable formulas and no circular references. • Logical structure with separate input, calculation, and output sections so anyone can follow the trail. • Summary dashboards and simple charts that highlight the key variances at a glance. • Straightforward cell naming and consistent formatting. Good written English is important because I will be asking questions and may need brief documentation explaining how each sec...

I need a sharp-turnaround assist for my upcoming Business Analytics laboratory exam that is entirely Excel-based. The exam will require me to build the underlying formulas that drive the analysis and then translate the results into a clear line graph, so I want a ready-to-use workbook that I can study and replicate during the test. Here is what I must walk away with: • A single Excel file containing the clean, well-labeled data range. • All core formulas and functions already in place—no array tricks or VBA, just efficient native functions that can be retyped quickly under exam conditions. • A professional-looking line graph that dynamically updates when any value in the data table changes. I will share a sample data set the examiners provided; please use it so I can...

I need an existing PDF invoice template converted into an Excel format for Mac. Requirements: - Must include: - Company logo - Table of items and prices - Payment terms and conditions - Formatting must match the PDF exactly - Automatic calculations are required Ideal skills and experience: - Proficiency in Excel on Mac - Experience with PDF to Excel conversions - Attention to detail to match formatting accurately - Familiarity with setting up automatic calculations in Excel

I have a set of records labelled “Data emtry” that must be transferred into a clean, well-structured Excel spreadsheet. You will receive the raw files and a template workbook with predefined columns; your task is simply to key every value into the correct cell, maintaining the original text and numbers exactly as shown. Accuracy is critical, so please double-check each entry before saving. When you finish, return the completed .xlsx file and keep the source material confidential. Let me know your estimated turnaround time and any clarifying questions you may have so we can get started right away.