Macros de Excel Jobs

I have several spreadsheets containing staff information that now need to be migrated into a cleaner, unified file. The source material is already in Excel, so you can work directly inside that environment without having to convert from paper or PDFs. For every record you will be entering three specific field groups exactly as they appear: • Name and contact details • Employment history and roles • Certifications and qualifications Consistency is critical—spelling, date formats, and credential abbreviations must match the source. A quick pass for obvious duplicates or incomplete lines before you hand the file back is also appreciated. Please send the finished workbook in .xlsx format. If you use any data-cleaning macros or Power Query steps, include them in th...

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 fully automated Excel bill for my trading business. The Excel sheet should be capable of generating invoices automatically. The invoices need to include: - Customer information - Product details - Payment terms Ideal skills and experience: - Advanced Excel skills - Experience in creating automated Excel templates - Attention to detail - Prior experience in invoicing for retail or trading businesses Please provide samples of similar work done.

Por favor, regístrate o inicia sesión para ver los detalles.

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

I have an urgent assessment to finish and need a specialist who truly understands Workforce Management logic inside Excel. You will receive one raw workbook that already holds the time-stamped data and all supporting assessment figures. Your main job is to turn that sheet into a clear-cut capacity-planning model, then walk me through the reasoning so I can present it with confidence. Here is what I am looking for: the model must calculate staffing requirements, shrinkage, occupancy, service-level projections and any other standard metrics you normally include for solid capacity planning. Forecasting and scheduling elements sit right behind this priority, so design the file in a way that lets me easily extend it to those areas. Accuracy is essential, but speed matters even more; I need fir...

My Excel workbook already contains a VBA macro that opens a PDF, extracts targetted numeric value from certain columns, aggregates them, and drops the results straight into specific cells. Functionally it works, yet it generates errors when it comes accross different number formats. I need a fast, tidy rewrite (or smart port) that does the same three core steps—read, parse & aggregate, write—within roughly three hours of coding time. You can choose the approach that lets you move fastest: streamline the existing VBA, replace it entirely with a Python routine built around pdfplumber, or create a hybrid where Python performs the heavy lifting and VBA simply updates the sheet. I’m comfortable with any of those paths as long as the final workbook remains a one-click solu...

I’m looking for a clean, reusable sales-invoice template built entirely in Microsoft Excel. The finished workbook must let me enter customer details, list product descriptions, and spell out payment terms without breaking the layout. For the product section I’d like full flexibility—sometimes a single line per item is enough, other times I need multiple descriptive lines or even a category breakdown. Please structure the sheet so any of those views can be shown or hidden easily. Automatic line totals, subtotal, tax, and grand-total formulas should already be in place, and all cells where I’ll type data clearly marked. A spot for my company logo and address would be helpful too. Deliverable: • One unlocked .xlsx file ready to use and modify later. If you&rsq...

PROJECT: Excel-Based Quotation System with Admin Control (MODA Windows & Doors) We need to develop a quotation system using Microsoft Excel (offline), with structured pricing logic, admin-controlled pricing tables, and manual PDF export. The system must be easy for sales users to operate while maintaining full control of pricing by the admin. 1. USER ROLES & ACCESS CONTROL There are two types of users: Admin Has full access to all sheets, including Pricing List and Customer Database. Can edit all pricing, unlock protected areas, and manage the system. User (Sales) Has access only to: - Customer List (restricted editing) - Quotation Sheet (data entry only) User cannot: - Access or modify Pricing List - Change formulas or pricing logic - Delete or edit customers without admin...

When I export my .xlsx workbook to PDF, what should be a single-page printout gets split across two pages. In Excel’s print preview everything fits neatly on one sheet, so I know the layout is correct inside the file; the problem appears only at the PDF stage. The sheet contains a mix of text labels and numerical data, no external links or macros. I need someone who can dive into the page-setup settings, scaling, margins, printer drivers or any other culprit and deliver a PDF that mirrors the one-page view I already see inside Excel. Ideally you’ll explain the tweak so I can apply it to future sheets too. Deliverable: • Updated workbook (or documented steps) that consistently exports to a single-page PDF matching Excel’s print preview.

I have a set of raw financial figures that still need a bit of tidying before they can reveal their story. Once the data is properly formatted in Excel, I need clear, well-labeled outputs for these descriptive measures: mean, median, plus the full spread of quartiles and percentiles. Please structure the workbook so that the cleaning steps (date or currency standardisation, removal of blanks, etc.) are transparent, then create the calculation area—whether that is with built-in functions, dynamic arrays or PivotTables is up to you, as long as the results update automatically when new records are dropped in. Deliverables: • A single Excel file containing: – A “Raw_Data_Clean” sheet with all prep formulas in place – A “Stats_Summary&rdquo...

I have several Excel spreadsheets filled with statistical entries recorded on different dates. I need the date columns repaired and standardised first, then a reliable way to compare each entry across the sheets so perfect matches surface immediately. Once the data is aligned, A small dashboard or set of charts inside the workbook is perfect; I want to see the movement at a glance. Everything must stay in .xlsx format. Use familiar Excel tools—formulas, conditional formatting, PivotTables, maybe Power Query if it speeds up the cleaning—so I can inspect or tweak them later. Deliverables: • Cleaned and consistently formatted spreadsheets • Automated comparison logic for the date-based entries • Standard deviation results for each metric • Tren...

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 run a small business and need our entire bookkeeping cycle captured accurately every month. The work covers day-to-day sales and purchase entries, updating the Cash Book and Bank Book, maintaining all ledgers, and closing each period with a balanced Trial Balance. The data must be recorded in both Excel and Tally; I use Tally for quick ledger look-ups while my partners prefer the flexibility of Excel. I already have a template in both platforms—once you come on board I’ll share these files so you can follow the exact layout we’re accustomed to. Deliverables each month • A fully updated Excel workbook that mirrors the structure I provide • The corresponding Tally data file with identical figures • A concise monthly report pack generated from th...

Διαθέτω έναν βασικό πίνακα 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 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...

Project Overview I have an existing Excel workbook used for job costing in a construction/striping business. The workbook is already functional and calculates costs based on quantities entered across multiple sheets (organized by item types such as striping widths, colors, markers, removals, etc.). Each sheet calculates unit pricing based on quantity tiers and produces totals. However, my current summary sheet only shows category totals (e.g., total striping, total removals) and does not provide a detailed, itemized breakdown. What I Want to Achieve I need to create a final summary sheet that dynamically pulls and displays ONLY the items used in a job, including: Item description (ex: 4” White Stripe, RPM Marker, etc.) Quantity entered Unit cost (based on the pricing logic alrea...

I need our simple logistics data-entry workbook turned into a smarter, mostly hands-off tool. Right now staff key information into a single base sheet, then we spend extra time copying, filtering and re-formatting that same data before it can be e-mailed to clients. I want to keep the base sheet as the only place anyone touches the raw figures, but have the rest happen automatically: • Guided data input – drop-downs, look-ups or forms that prevent typos and ensure each required field is filled. • One-click data output – macros or Power Query that transform the base data into clean, customer-ready sheets (PDF or XLSX) and save them to a specified folder, ready to attach to an e-mail. Because all finished files go out as e-mail attachments, the generated sheets mu...

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 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 have a collection of PDF documents whose tables and text need to be transferred accurately into an Excel sheet. At the same time, I also need a set of subtitle files translated from English into clear, natural-sounding French. Here’s what I’m aiming for: • Data from each PDF copied precisely into the matching columns of my provided Excel template, with no omissions or typos. • SRT or VTT subtitle files translated line-by-line, keeping timestamps intact and respecting character limits so the on-screen text reads smoothly in French. • Consistent terminology across both tasks; any unclear phrases flagged for confirmation rather than guessed. I will supply: – The source PDFs – The Excel layout showing required columns – The original Engl...

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

我正在同时推进两项内容，需要一位熟悉办公软件与视频编辑的伙伴协助完成： 1. Excel表格 • 根据我提供的原始数据，建立结构化工作表 • 使用常用函数（如VLOOKUP、SUMIF、透视表等）整理与汇总 • 套用清晰的格式与颜色标注，方便后期查阅与打印 2. 教学视频剪辑 • 原片长度约 10–15 分钟，需删减空白、卡顿与多余段落 • 加入片头片尾、淡入淡出转场和背景音乐（我可提供素材，也可接受你推荐的免版税音乐） • 配置简洁字幕与关键步骤提示，最终导出 1080p MP4 请在申请中侧重分享你在 Excel 自动化或视频剪辑（Premiere、Final Cut、DaVinci Resolve 等）的相关经验，最好能附上一两个成品链接或截图，便于我快速评估成效。 交付时间、具体工作流程和任何疑问都欢迎在沟通中进一步确认。期待与你合作！

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.

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.