มาโครใน Excel Jobs

I have a batch of scanned documents that need to be keyed into an Excel spreadsheet exactly as they appear. Every field—names, dates, reference numbers and totals—must match the source images without relying on OCR. I will supply: • the PDF set of scans • an Excel template that shows the required column order and any pre-filled validation rules Your deliverable is the completed spreadsheet, cleanly formatted and ready for immediate use in our internal system. Please double-check figures and spelling before submission; I will run a spot check across several random records to confirm accuracy. If anything is unclear in a scan, flag it in a separate tab so we can resolve it quickly. Accuracy and a steady turnaround matter more than speed alone, but once we are confi...

I want to replace a string of repetitive, error-prone steps in my workbook with a clean, well-documented VBA macro. The end result should run at the click of a button or a keyboard shortcut, carry out every step automatically, and leave the sheet ready for review without any manual fixes. Deliverables • The Excel file containing your fully commented VBA code • A short note (or Loom/video) explaining how to install, edit, and trigger the macro in Excel 2016, 2019, and Office 365 • Clear documentation of any external references or libraries you use Acceptance criteria • Macro executes from a single action with no run-time errors • Code is logically structured and easy for me to tweak later • Operation remains consistent across all three Excel v...

I have six to ten PDF files filled with neatly structured tables that must be recreated in Excel. Every value, symbol, row, and column needs to appear exactly as in the originals so the final workbook mirrors the source documents without a single discrepancy. Accuracy is non-negotiable, so please lean on Adobe Acrobat, reliable PDF-to-Excel utilities, and precise OCR techniques to prevent misreads. Before tackling the full batch, share a short sample from the first file so we can confirm layout and formatting. Deliverables • Excel workbook(s) that replicate each table perfectly • No data loss—figures in Excel must reconcile with the PDFs • Confirmed sample prior to full submission Once the sample is approved, a swift turnaround on the remaining files will keep...

I run a catering business and I’m ready to replace my spreadsheets with a single ERP that takes care of everything from the first quotation to the final profit report. The platform must let me build and send quotations through the system’s own messaging module, log every expense against each event, and compare that to incoming payments so I always see real-time profit. Key deliverables I expect: in excel • Quotation module that turns event details into branded PDFs and pushes them to clients via the built-in messaging channel. • Expense and income tracking tied to each event, with simple dashboards that show overall cash flow as well as event-by-event profitability. • Automatic monthly reports I can export or print for my accountant. A clean, intuitive w...

I need a brief, heartfelt note written purely for personal use. The tone should be warm, genuine, and no longer than a single paragraph—something I can share as-is without further polishing. Once we start, I’ll provide the key sentiment and any names or details that must be included; you bring the eloquence and flow. To help me choose the right writer, please attach a sample of past work that shows your ability to craft concise, emotive prose. A simple text or Word file is fine. The final deliverable should arrive as an editable document so I can tweak it if needed.

I need assistance with VLOOKUP to match and fetch inventory numbers. Requirements: - Use of VLOOKUP to match and fetch inventory numbers. - Work with multiple sheets within one workbook. Ideal Skills: - Proficiency in Excel, especially with VLOOKUP. - Experience handling multiple sheets in a single workbook. - Attention to detail to ensure data accuracy.

I'm seeking an experienced VBA developer to create an Excel macro. The primary goal is to automate reporting tasks to save time and reduce manual effort. Key Requirements: - Develop a VBA macro to automate repetitive reporting tasks. - Ensure the macro is user-friendly and well-documented. - Provide support for any troubleshooting post-deployment. Ideal Skills and Experience: - Proficiency in Excel and VBA. - Strong experience in automating tasks, particularly in reporting. - Problem-solving skills and attention to detail. Please provide examples of past work and relevant experience in your application.

Excel Dashboard Enhancement & Automation Overview I have an existing Excel workbook used for monitoring and reporting ESP well operations in (X) area. The workbook already contains multiple sheets, formulas, logs, and operational data. I am looking for an Excel expert to redesign, automate, and improve the workbook while maintaining all existing functionality and calculations. This is not a simple formatting task. The workbook contains many formulas, linked sheets, operational KPIs, and engineering data. I need someone with strong Excel expertise (advanced formulas, Power Query, VBA if needed, dashboards, automation, and workbook architecture). Experience using AI tools for data visualization, dashboard design, and workflow optimization is highly preferred. Main Objective Create ...

I’m looking for someone who enjoys tidy spreadsheets as much as I do. I’ll provide a raw data file containing customer information; you’ll enter each record into Excel, verify every cell for completeness and accuracy, and keep the sheet logically organised throughout. Once the data is in place, I need the workbook’s financial section laid out as a standard balance sheet, so familiarity with typical financial-statement headings and column structure is essential. Accuracy is critical—numbers, dates and names must match the source exactly—and the finished workbook has to look polished, with clear headings, consistent number formats and no stray rows or merged-cell surprises. If you’re comfortable moving quickly in Excel (filters, conditional format...

I’m looking for someone who enjoys tidy spreadsheets as much as I do. I’ll provide a raw data file containing customer information; you’ll enter each record into Excel, verify every cell for completeness and accuracy, and keep the sheet logically organised throughout. Once the data is in place, I need the workbook’s financial section laid out as a standard balance sheet, so familiarity with typical financial-statement headings and column structure is essential. Accuracy is critical—numbers, dates and names must match the source exactly—and the finished workbook has to look polished, with clear headings, consistent number formats and no stray rows or merged-cell surprises. If you’re comfortable moving quickly in Excel (filters, conditional format...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas ...

# Advanced Excel Study Planner & Performance Dashboard (RRB PO, SBI PO, SSC) ## Project Overview I need a professional, full-featured study-planning workspace built entirely in Microsoft Excel (Excel 2016+ compatible) for competitive exam preparation, specifically RRB PO, SBI PO, IBPS PO, SSC CGL, SSC CHSL, and similar aptitude-based examinations. The workbook should function as a complete planning, tracking, and performance-management system, allowing me to create fully customizable study schedules (daily, weekly, monthly, or hour-based), monitor progress automatically, analyze mock-test performance, and identify weak areas through interactive dashboards. The final deliverable should be clean, professional, optimized for performance, and suitable for long-term use without requirin...

I have an Excel file that’s meant to build a self-populating work roster, but the dashboard sheet is no longer talking to the roster grid. The Generate Roster button sits there looking pretty, yet nothing happens. What it should be doing is cycling through my predefined staffing rules—roles, shift lengths, maximum hours—and auto-filling the grid instantly. The core of the job is to trace where the VBA (or assigned macros) break down, restore the link between the dashboard inputs and the roster sheet, and make sure the Generate Roster button actually produces a complete schedule every time. Once fixed, I need clean, well-commented code so I can tweak the rules later without breaking everything again. Deliverables: • Working Generate Roster button that auto-fil...

I have a collection of text-based records that must be transferred accurately into Excel and then processed with a short Python routine. Everything will be keyed in manually—no web scraping or database pulls—so precision and an eye for detail are critical. The spreadsheet should come back tidy, well-formatted, and ready for basic filtering or pivoting. Once the sheet is complete, I’d like a lightweight Python script (pandas / openpyxl are fine) that reads the file, performs simple cleaning steps I’ll specify, and exports an updated version. If any numeric fields appear along the way, just include them exactly as the client supplies; no additional analysis is required. Deliverables • Finished Excel workbook with all text data correctly entered • P...

I have a collection of text-based records that must be transferred accurately into Excel and then processed with a short Python routine. Everything will be keyed in manually—no web scraping or database pulls—so precision and an eye for detail are critical. The spreadsheet should come back tidy, well-formatted, and ready for basic filtering or pivoting. Once the sheet is complete, I’d like a lightweight Python script (pandas / openpyxl are fine) that reads the file, performs simple cleaning steps I’ll specify, and exports an updated version. If any numeric fields appear along the way, just include them exactly as the client supplies; no additional analysis is required. Deliverables • Finished Excel workbook with all text data correctly entered • P...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas a...

I’m looking for someone who enjoys tidy spreadsheets as much as I do. I’ll provide a raw data file containing customer information; you’ll enter each record into Excel, verify every cell for completeness and accuracy, and keep the sheet logically organised throughout. Once the data is in place, I need the workbook’s financial section laid out as a standard balance sheet, so familiarity with typical financial-statement headings and column structure is essential. Accuracy is critical—numbers, dates and names must match the source exactly—and the finished workbook has to look polished, with clear headings, consistent number formats and no stray rows or merged-cell surprises. If you’re comfortable moving quickly in Excel (filters, conditional format...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas ...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I run compliance for a busy haulage company and need a single Excel workbook that keeps me ahead of every statutory obligation. The sheet must revolve around our WEEKLY TARGETS: when each licence, CPC refresher, driver medical or maintenance inspection is due, what percentage of the fleet is still outstanding, and whether we are on-track for the week. Here’s what I picture: the moment any target slips inside its warning window the cell turns amber; miss the deadline and it flips to red. At the same time an automatic email should leave Outlook so the relevant manager is warned without me lifting a finger. Formulas must update themselves from simple data entry (dates, counts, kilometres, etc.), calculate the remaining days and the KPI percentages, and feed a quick-view dashboard so I ...

I need mixed text-and-numeric information transferred into a clean, well-structured Microsoft Excel file. Because no template exists yet, the first step is to design a workbook layout that groups the data logically, uses appropriate data types, and includes basic validation to minimize entry errors. The structure should include features like dropdown menus, data validation rules, basic formulas where appropriate, and clear formatting for ease of use. Once the format is approved by me through a submitted sample layout or brief guidelines, enter all supplied records, double-checking for typos, misplaced decimals, and inconsistent labels to achieve utmost accuracy. Key deliverables: • Custom Excel template with clear headings, data-validation rules, dropdown lists, and basic formulas ...

I have an Excel workbook filled with mixed data—text, numbers, the usual combination—that needs to be transformed into about 100 different pdf. they all have the same data, but each is from a different organization. The final documents must all have the same data, but each on their different PDF template (NO OCR). Deliverables: • A working script or macro that pulls the mixed data row-by-row and produces individual, consistently filled PDFs. • Sample output showing at least three generated PDFs so I can verify design accuracy before full production. I’ll supply the PDF assets and the Excel file once we start.

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

I need purpose-built Excel files that handle two day-to-day bookkeeping areas—Accounts Payable/Receivable and Payroll management—and then roll everything up into clean, ready-to-share financial reports. Here is what I want to walk away with: • A dynamic AP/AR workbook that lets me record invoices, tag payments, and instantly show outstanding balances. • A payroll tracker that calculates gross-to-net, accrues benefits, and updates year-to-date figures automatically. • A consolidated reporting sheet (or dashboard) that pulls data from both workbooks and produces the standard financial statements I rely on. I work almost exclusively in Excel, so strong command of formulas, pivot tables, lookups, and—where it speeds things up—macros or Power Q...

Saya membutuhkan bantuan untuk menyusun sebuah laporan keuangan di Excel yang rapi, mudah dipahami, dan siap dipresentasikan. Fokus utamanya adalah rekapitulasi transaksi bulanan—mulai dari pemasukan, pengeluaran, hingga saldo akhir per bulan—dengan format tabel yang jelas serta rumus otomatis agar angka selalu akurat saat data diperbarui. Ruang lingkup pekerjaan: • Merancang template laporan keuangan berbasis Excel, lengkap dengan header, periode, dan kategori transaksi. • Membangun rumus dan referensi sel sehingga total, subtotals, serta saldo dihitung otomatis. • Menyiapkan ringkasan bulanan yang memudahkan saya melihat perbandingan antar bulan. • Menambahkan conditional formatting sederhana untuk menyorot angka negatif atau melebihi batas tertentu...

hello, I need to create a solution in Excel that I would use to print school certificates... on the first Excel sheet I would enter general information about the school, teacher's name, number of students and class and by pressing the "generate" button it would open a new Excel sheet in which I would create a table overview of all subjects and calculate average grades... the data entered on the second sheet should be used on the third sheet to print the certificate. I would like to submit an outdated proposal of how it would look and how we used to use the certificate form on which the data should be printed More details: What kind of overview do you need on the second sheet? Grades and attendance What format do you prefer for the certificate on the third sheet? Custom te...

ROYAL HOSPITAL FOR WOMEN PGD / PGT PATIENT TRACKING WORKBOOK FINAL DESIGN (VERSION 1.0) ________________________________________ SHEET 1 – LANDING PAGE (DAILY WORKFLOW) Purpose The Landing Page is the nursing team's operational workspace. No patient data is entered here. All information is automatically populated from the Master Register. ________________________________________ Landing Page Layout WL# URN Surname First Name DOB Current Age Age at Referral Referral Date Days Waiting Genetic Diagnosis Status Next Action Appointment Date Due Date Example WL# URN Surname First Name DOB Current Age Age at Referral Referral Date Days Waiting Genetic Diagnosis Status Next Action Appointment Date Due Date 1 12345 Smith Jane 15-04-1992 34 33 01-08-2025 335 BRCA1 New Referral Offer Appoi...

I need a dynamic Excel spreadsheet to track host release times and shift timings across three clusters (Cluster A, Cluster B, Cluster C) with more than 10 hosts in each. Requirements: - Three clusters - Multiple hosts per cluster (more than 10) - Three shifts, each lasting eight hours - One host released per cluster each hour per shift - Dynamic and easy to read Ideal Skills: - Proficiency in Excel - Experience with dynamic data tracking - Attention to detail