Excel Macros Jobs

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 have a set of purely numeric records that must be transferred into Microsoft Excel with absolute accuracy. Because I don’t have an existing template, you’ll create a clear, well-structured workbook from scratch, choosing columns, headings, and basic formulas so the figures are easy to read and verify. All data provided will be numbers only, so speed keys such as flash-fill, data validation, or simple SUM/AVERAGE formulas are welcome if they help maintain consistency without over-engineering the file. What matters most is error-free entry and a logical layout. Timing: an initial draft is expected within the next 2–3 days; the final, polished version must be delivered within a month at the latest. Deliverables • One Excel (.xlsx) workbook containing every numeri...

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 someone long term to help me and be compensated weekly for filling out 100 contact forms a day and completing to perfection one excel document a day or filling out 200 contact forms a day . All forms require before and after screenshots and initial pay is $5 a week with a $1 a week raise per week until $35 a week is achieved in compensation, must meet all goals, and may take either Saturday or Sunday day off weekly

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 purely numeric records that must be transferred into Microsoft Excel with absolute accuracy. Because I don’t have an existing template, you’ll create a clear, well-structured workbook from scratch, choosing columns, headings, and basic formulas so the figures are easy to read and verify. All data provided will be numbers only, so speed keys such as flash-fill, data validation, or simple SUM/AVERAGE formulas are welcome if they help maintain consistency without over-engineering the file. What matters most is error-free entry and a logical layout. Timing: an initial draft is expected within the next 2–3 days; the final, polished version must be delivered within a month at the latest. Deliverables • One Excel (.xlsx) workbook containing every numeri...

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

I have a collection of printed documents that contain strictly numerical information—no text fields, just figures that need to be transcribed verbatim into a clean Excel workbook. Accuracy is critical because these numbers feed directly into later calculations. You will receive high-resolution scans (PDF). Your task is to key every value into the corresponding columns and rows I specify, double-check totals or subtotals where they appear, and hand back an .xlsx file ready for immediate use. Deliverables • One Excel workbook mirroring every number shown in the prints • A brief note of any illegible or ambiguous figures you encounter I expect meticulous attention to detail, familiarity with Excel’s basic validation tools, and a quick turnaround once the scans arriv...

I need a clear, practical walk-through of Excel that focuses first on feeling at home with the Tabs—how to locate key commands quickly and move between the different groups inside each tab. Once that foundation is solid, I want to practise routine data entry so I can drop text, numbers, and date values into the right cells without slowing down. The last piece is basic but essential formatting: switching fonts, shading or colouring cells for emphasis, and adding crisp borders so my sheets look tidy and professional. Please guide me step by step, share best-practice shortcuts as we go, and make sure I can repeat every action confidently on my own by the end of the session.

My Excel workbooks suffer from frequent duplicate records, inconsistent formatting, and other invalid values spread across multiple sheets. I need a specialist who can systematically scan every column and row, eliminate duplicates, apply consistent number/date/text formats in line with my basic house-style rules, and flag or correct any entries that fall outside logical ranges. The datasets are large, so I expect you to lean on efficient methods—Power Query, VBA macros, or advanced formula workflows—rather than manual spot-fixing. Once complete, the file should open without errors, pass a quick filter test for duplicates, and display uniform cell styles throughout. Deliverables: • A fully cleansed, consistently formatted Excel workbook. • A brief change log summar...

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 need a solution to automate the generation of financial reports using data from Excel spreadsheets. Requirements: - Automate report generation process - Utilize Excel spreadsheets as data source Ideal Skills: - Expertise in Excel and automation tools - Experience with financial report generation - Familiarity with integrating Excel with automation software

Excel VBA was working properly until last month. But currently not working. I am looking for a VBA developer. I think 30mins or 1 hour is enough to resolve.

My Excel workbooks suffer from frequent duplicate records, inconsistent formatting, and other invalid values spread across multiple sheets. I need a specialist who can systematically scan every column and row, eliminate duplicates, apply consistent number/date/text formats in line with my basic house-style rules, and flag or correct any entries that fall outside logical ranges. The datasets are large, so I expect you to lean on efficient methods—Power Query, VBA macros, or advanced formula workflows—rather than manual spot-fixing. Once complete, the file should open without errors, pass a quick filter test for duplicates, and display uniform cell styles throughout. Deliverables: • A fully cleansed, consistently formatted Excel workbook. • A brief change log summar...

I need an automated order book organized by product type. The data should include: - Product details - Order status It should be adaptable to a 4-inch printer in a compact list format. Ideal skills and experience: - Experience with automation tools - Ability to design printer-friendly layouts - Familiarity with order management systems Looking for a clean, efficient solution.

I need a specialist who can build robust, reusable Excel 365 formulas for an existing workbook. The work centres on creating truly advanced logic rather than simple cell references. In practical terms, every formula you write must: • include reliable error handling so any #N/A, #DIV/0! or similar issues are gracefully managed • use nested functions where they provide the cleanest, fastest solution • trigger conditional formatting rules that instantly flag results requiring attention I will supply a sample file with annotated targets and a brief “business-rules” document describing what each output should show. Your job is to translate those rules into efficient formulas, test them in Excel 365, and return the updated file together with a short explanation...

I have a collection of Excel (.xlsx) files containing text-only records that need to be copied, verified, and placed into a new master spreadsheet I will provide. The job is straightforward yet demands close attention to spelling, spacing, and column alignment—no numerical fields, formulas, or calculations are involved. You will receive the source workbooks via a shared drive link. Your tasks are to: • Open each sheet, copy the text exactly as written, • Paste it into the matching columns of the template I supply, and • Double-check for any accidental truncation or hidden characters before saving. A quick turnaround with zero introduced errors is my priority. When you return the completed master file, I will spot-check several rows; if everything matches the ori...

I run a hydroponic service company and the bank has asked for a fresh Credit Monitoring Arrangement (CMA) projection. I need a complete one-year model that stands up to lender scrutiny and clearly tells the story of our cash needs and growth path. The work revolves around three core statements—income statement, balance sheet, and cash-flow statement—built month-by-month, tied together, and driven by transparent assumptions. Please build everything in a clean, well-annotated Excel workbook so I can trace every input. Deliverables • Excel file with linked Income Statement, Balance Sheet, and Cash-Flow tabs covering 12 months • Separate assumptions tab showing revenue drivers, cost structure, funding terms, and cap-ex for the hydroponic operations • A brief ...

My Excel workbooks suffer from frequent duplicate records, inconsistent formatting, and other invalid values spread across multiple sheets. I need a specialist who can systematically scan every column and row, eliminate duplicates, apply consistent number/date/text formats in line with my basic house-style rules, and flag or correct any entries that fall outside logical ranges. The datasets are large, so I expect you to lean on efficient methods—Power Query, VBA macros, or advanced formula workflows—rather than manual spot-fixing. Once complete, the file should open without errors, pass a quick filter test for duplicates, and display uniform cell styles throughout. Deliverables: • A fully cleansed, consistently formatted Excel workbook. • A brief change log summar...

I run a chartered-accountancy practice in Basti, Uttar Pradesh and am looking for an ADCA-qualified article assistant who can stay with the firm for up to three years. Your core responsibility will be documentation preparation, specifically drafting and finalising complete sets of financial statements for our clients. On a typical assignment you will pull data from Tally ERP or Excel workbooks, prepare balance sheets, income statements and cash-flow notes, plug supporting schedules into the ICAI-prescribed formats, and export clean, audit-ready PDFs. While client interaction and in-depth analysis remain in-house, I rely on you for speed, accuracy and strict confidentiality. Key tools in daily use include Tally ERP, advanced Excel (pivot tables, lookups, macros), Word and basic GST/MCA po...

I need a clear, investor-focused KPI dashboard built in Excel that lets me monitor the health of a property portfolio at a glance. The workbook should automatically pull or accept monthly figures, then present each metric side-by-side in both clean tables and intuitive charts so investors can drill down or get a quick snapshot during meetings. Core KPIs to visualise • Occupancy rate • Rental income • Maintenance costs • Planned-preventive maintenance (PPM) status • Lease expiry timeline • New lease count • Tenant satisfaction score • Budget vs. actual spend • Cost variance • Utility cost trends • Average rent per sqm What I expect – One Excel file with an easy “Data” sheet for raw inputs and se...

I need text copied from several digital Excel sheets into one clean, consolidated workbook. Every cell must match the source exactly, including capitalization, spacing, and line breaks. What you’ll do: • Open each supplied Excel file. • Transfer all text data into the designated master sheet, keeping original column order. • Run a quick spell-check and flag any gaps or unclear entries for my review. Deliverable: a single Excel file containing the fully merged and verified text dataset. Please let me know how soon you can start and your typical turnaround time for similar projects. Accuracy and attention to detail are essential; if you’re comfortable with Excel functions, filters, and basic data validation, this will be a straightforward task.

I’m looking for an online accountant who can communicate comfortably in Arabic and devote their attention exclusively to bookkeeping. Each week I’ll forward bank statements, sales records, and expense receipts; your task is to turn that raw data into clear, reconciled Excel reports. What I expect • Full bank and transaction reconciliation so our ledgers are tidy and verifiable. • A neatly formatted Excel workbook containing a profit-and-loss, balance sheet, and brief cash-flow snapshot, delivered in both Arabic and English headers. - Weekly Report and short call to discuss bookkeeping. • The completed monthly report and file sent by the 7th of every month, with a brief call or voice note to walk me through any anomalies. No tax preparation or wider financ...

I have a timed business-lab Excel exam coming up and I want a skilled eye to back me up while I work through it. The exam focuses on three core areas: building clean pivot tables, running quick yet accurate data analysis, and writing (or troubleshooting) formulas and functions so the answers balance out perfectly. During the session I may also be asked to turn the pivot results into both tables and charts, so being comfortable switching from analysis to presentation on the fly is important. Visualisations are not confirmed yet, but if they appear I will need simple, clear chart layouts that an instructor can read at a glance. What I need from you: • Real-time guidance (chat, call, or screen-share) as I move through each question. • Fast problem-solving—especially when...

i have layout of furniture work need 3d design

I work with large sets of financieros and need to speed up my audit procedures inside Excel. I’m looking for a VBA-driven workbook (or an add-in, whichever you find cleaner) that automates two specific sampling approaches I use every week: Random sampling • Let me pick the population range (rows or a Power Query table) and the sample size or confidence level. • Your code must perform a selección aleatoria de registros, drop them into a separate tab, and—within the same run—crear un informe de muestra que detalle método, parámetros y resultados. • Before it finishes, the macro should validar los resultados de la muestra (duplicates, gaps, correct count). MUS (Monetary Unit Sampling) • Starting from the same financial popul...

I need a basic Excel-based training tracker to monitor employee progress for his skill level. For example, there is 100 tasks to complete for the employee to be awarded his next level etc. The tracker sheets have to cross reference the first sheet where there will be an overall progress sheet of the percentage of tasks completed, name of the worker, total tasks. Etc - User-friendly interface - Ability to monitor progress through upgrade training Ideal Skills and Experience: - Proficiency in Excel - Experience creating tracking tools - Attention to detail I can provide an example but not copy exact design.

I’m ready to replace my scattered spreadsheets with a single, purpose-built Excel workbook that acts as a light CRM for my finance practice. The file has to let me enter and view three kinds of data—client information, their financial transactions, and the tasks I’m tracking for them—in one place. From there I want to see quick client summaries, produce straightforward financial reports, and monitor task status without jumping into any external accounting or email tools; this workbook should stand completely on its own. I’m comfortable with formulas and basic filtering, but I’ll need you to set up the underlying tables, relationships, and any VBA or Power Query automation required to make the user experience smooth (drop-down menus, one-click report ref...

I’m ready to replace my scattered spreadsheets with a single, purpose-built Excel workbook that acts as a light CRM for my finance practice. The file has to let me enter and view three kinds of data—client information, their financial transactions, and the tasks I’m tracking for them—in one place. From there I want to see quick client summaries, produce straightforward financial reports, and monitor task status without jumping into any external accounting or email tools; this workbook should stand completely on its own. I’m comfortable with formulas and basic filtering, but I’ll need you to set up the underlying tables, relationships, and any VBA or Power Query automation required to make the user experience smooth (drop-down menus, one-click report ref...

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 visuelle ne nécessita...