Excel Macros Jobs

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

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

I have several Excel sheets that hold both text and numbers and I need every record transferred, by hand, into a master template I will provide. Accuracy is critical—no copy-paste macros or automated scraping—just careful manual input so the final file mirrors the source exactly, including formatting such as date and currency styles. You’ll receive: • A folder of the original Excel workbooks • My blank master template and a short set of field-by-field notes Your task is simply to work through each sheet, key in the corresponding values, and double-check totals or formulas so nothing is lost in translation. When you return the completed template I will run a spot check; if everything aligns, the job is done. Familiarity with Excel’s basic func...

I have several Excel sheets that hold both text and numbers and I need every record transferred, by hand, into a master template I will provide. Accuracy is critical—no copy-paste macros or automated scraping—just careful manual input so the final file mirrors the source exactly, including formatting such as date and currency styles. You’ll receive: • A folder of the original Excel workbooks • My blank master template and a short set of field-by-field notes Your task is simply to work through each sheet, key in the corresponding values, and double-check totals or formulas so nothing is lost in translation. When you return the completed template I will run a spot check; if everything aligns, the job is done. Familiarity with Excel’s basic func...

The workbook I rely on daily contains an existing VBA macro that should handle several automation steps for me, yet its current logic is off and the tasks don’t complete in the right order—or sometimes not at all. I need a developer who can step through the code, identify exactly where the flow breaks down, and rewrite those sections so the automation runs reliably every time the file is opened or the button is clicked. Here’s what I expect once the job is done: • The macro executes its full task sequence without manual intervention or unexpected stops. • Any loops, conditional branches, and object references are cleaned up so they’re easy to maintain. • I receive the updated workbook plus a brief changelog (commented in-line or a separate note...

I need a single Excel workbook that lets me enter raw sales data and instantly turns it into professional-looking bills. The sheet must pull every essential detail into the final print-ready invoice: • Customer information: name, full contact details, address, and account number • An itemised list of products or services with quantities, rates, and line totals • Clearly shown payment terms, plus auto-calculated subtotals, tax, discounts, and grand total Date handling is important—each invoice should grab the sale date, stamp a configurable due date, and feed those dates into a running tally so I can track what’s outstanding. A summary page that aggregates totals by day, week, and month will help me reconcile figures quickly. Please build the logic with s...

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

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’ll send you an updated Excel workbook that contains several sheets. Your job is simple but must be done precisely: • Ensure every sheet keeps the exact column order, data types, and overall look we used in week 21—no unexpected formatting changes. • If anything was added across sheets, merge all columns so the structure stays identical throughout the workbook. • Upload the finished file to the designated SharePoint folder, replacing the prior week’s version. • Confirm the dataset still refreshes in Power BI without errors (no deep modelling required, just a quick check). Because the source is spread over multiple sheets and the downstream report relies on consistent formatting, strong Excel skills—tables, Power Query, data validation&md...

I need a complete workflow that starts with a clean, well-structured Excel Bill of Materials and ends with that same BOM living accurately inside our Siemens Teamcenter instance. Here is the flow I have in mind: • Build an Excel template that carries our company branding in the header and footer. All columns must follow the layout we already use internally, so I can hand the sheet to any engineer and have them recognise it instantly. • Populate the template with a representative “company BOM” so we can prove the import routine. • Import or map that sheet into Teamcenter, creating the BOM exactly as it appears in Excel—same hierarchy, item numbers, revisions, and descriptive fields. • Demonstrate the result in Teamcenter to confirm every part an...

I need an Excel sheet with multiple tabs to manage student information for school districts. Each tab should be dedicated to a different district, and within each tab, I want sub-tabs for organizing student data. Requirements: - Each main tab represents a different school district - Sub-tabs within each district for organizing student data broke down by schools - Data to track: Personal details (name, dob school name school address ID # Need the sheet built Ideal Skills and Experience: - Proficiency in Excel, including advanced functions and tab management - Experience with data organization and management in spreadsheets - Attention to detail and accuracy in data entry Please provide samples of similar Excel projects.

I need an Excel expert to help with data analysis. Requirements: - Create complex formulas and functions - Develop pivot tables and charts - Analyze data sets and provide insights - Ensure data accuracy and integrity Ideal Skills and Experience: - Proficiency in Excel, especially in data analysis tools - Strong analytical skills - Prior experience in similar projects - Ability to meet deadlines and communicate effectively

I need one of my existing Excel workbooks cleaned up so it’s clear, consistent, and presentation-ready. This involves applying a cohesive layout, organizing columns and rows logically, and setting up styles that make the data easy to read at a glance. If you see opportunities for conditional formatting, data-validation drop-downs, or smarter formulas that improve accuracy, feel free to suggest and implement them—I’m open to best-practice improvements. The final file should open without any warnings, print neatly on standard paper sizes, and be fully compatible with the latest desktop and Microsoft 365 versions of Excel. Once the finished workbook looks polished and functions smoothly, please walk me through the key changes so I can maintain it going forward.

I have several spreadsheets that are ready for a final pass of data validation. The sole focus is accuracy and consistency across every row and column—no scraping or fresh data entry is required. You will receive the original Excel files along with a short set of business-logic rules. Please work through each sheet, use the validation tools you prefer (Excel filters, conditional formatting, VLOOKUP/XLOOKUP, Google Sheets equivalents, etc.), correct any straightforward errors, and flag anything unclear so I can make the final call. Deliverables • The same spreadsheets returned, fully validated and saved in their original format • A concise log or extra tab listing all changes made plus any questions that still need my review Acceptance criteria • 100 % of f...

I'm looking for an experienced Excel expert to create a comprehensive CRM and lead management system tailored to my needs. Key Requirements: - Track customer information and sales pipeline - Manage customer interactions with: - Notes section - Automated follow-ups - Email integration - Generate reports on: - Sales performance - Lead conversion rate Ideal Skills & Experience: - Advanced proficiency in Excel - Experience in building CRMs in Excel - Strong understanding of sales and lead management processes - Ability to create automated systems within Excel - Excellent organizational skills

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

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

Procuro um profissional com experiência avançada em Microsoft Excel (ou Excel com VBA/Power Query/Power Pivot) para desenvolver um sistema de gestão de stock personalizado. O objetivo é criar uma solução simples e eficiente que permita: Registo de entrada de mercadorias no stock. Cadastro de novos produtos com referência, descrição, quantidade e outras informações relevantes. Registo de vendas, com baixa automática do stock sempre que uma venda for efetuada. Controlo em tempo real das quantidades disponíveis. Alertas de stock baixo (opcional). Registo de encomendas/reservas de clientes. Histórico de clientes e respetivas encomendas. Campo para registar a data de chegada da encomenda. Campo par...

Saya ingin seluruh proses pembuatan laporan kinerja di tim kami berjalan otomatis langsung dari file-file Excel yang sudah ada. Saat ini data performa di-update harian, lalu kami masih menyusun grafik, pivot, dan rangkuman KPI secara manual—memakan waktu dan rawan salah. Ruang lingkup yang saya butuhkan: • Merancang template Excel yang menarik sekaligus efisien, siap menerima input harian tanpa perlu copy-paste. • Membuat macro / VBA atau Power Query yang secara otomatis: – menarik data baru, – membersihkan dan memvalidasi input, – memperbarui tabel pivot dan grafik kinerja, – menghasilkan sheet ringkasan KPI mingguan dan bulanan. • Menyertakan tombol atau shortcut sederhana agar staf non-teknis cukup klik sekali untuk memperb...

Saya ingin membuat sistem akuntansi keuangan sederhana di Microsoft Excel dan membutuhkan bimbingan langsung dari Anda. Fokusnya hanya pada pencatatan data—membuat sheet transaksi, jurnal, buku besar, serta laporan dasar seperti neraca saldo tanpa analisis mendalam. Apa yang saya harapkan: • Template spreadsheet siap pakai dengan struktur tabel yang rapi. • Panduan langkah-demi-langkah (video singkat atau dokumen) tentang cara memasukkan dan memposting transaksi. • Penjelasan fungsi-fungsi Excel yang relevan (mis. SUMIF, VLOOKUP, pivot table dasar) agar saya dapat memperbarui data sendiri di kemudian hari. • Sesi tanya jawab singkat untuk memastikan saya memahami alur kerjanya. Tidak diperlukan integrasi software lain—semua dikerjakan di Excel. Jika ...