Excel SUMIFS Dynamic Range
I’m looking for a clean, reusable way to make the SUM range inside a SUMIFS formula shift automatically in Microsoft Excel whenever my start-date or end-date ce...
Read more
ID / Date
Listing
Link
Tiny Home Community Excel Tracker
I need an advanced Excel spreadsheet to manage the development of a tiny home community with over 50 homes. The spreadsheet should track: - Construction timelin...
Read moreExcel Sales Data Cleanup & Insights
I have several Excel workbooks filled with raw sales transactions that first need to be cleaned and organized—duplicates removed, dates standardized, product co...
Read moreSales MIS Report Creation
I have a raw sales dataset that needs to be transformed into an MIS report that lets me see the big picture and drill right down to individual transactions—all...
Read moreDynamic Excel Gantt Schedule
I need a single-sheet Excel file that lets me manage a 30-day project in a clear Gantt-style view. The sheet has to accommodate up to 10 companies and 50 indivi...
Read moreRevise Excel Sum Formulas
I have an Excel workbook called “School Slices Label Form.” The sheet already contains formulas, but several of the sum and total calculations are no longer ret...
Read moreCorrupted Excel File Recovery
My primary Excel workbook (and the only backup I have) refuses to open—both files appear to be corrupted, so I cannot even preview the data. I need someone expe...
Read morePrevent changing vbaProject.bin variables in an xlsm file
I need a robust way to stop anyone from renaming my macro-enabled Excel file to .zip, extracting vbaProject.bin, tweaking the CMG / DPB / GC keys (they become C...
Read moreClean & Format Excel Data
I have several Excel workbooks containing a mix of text and numerical fields that need to be prepared for downstream reporting. The files are in their raw state...
Read moreExcel Revenue Data Analysis
I have a collection of raw numerical figures that represent monthly and quarterly sales. The goal is to move this data into a well-structured Excel workbook and...
Read moreConvert Access Database to Excel
I need a Microsoft Access .accdb file converted into a user-friendly Microsoft Excel file. Key Requirements: - Retain functionalities: - Data entry forms - Auto...
Read moreAutomated Excel Workbook for Data Consolidation
I have two spreadsheets that I export from my work order management system: 1. Clients sheet – contains client details. 2. Properties sheet – contains property...
Read moreAccurate Sales Data Entry & Reports -- 2
Over the next two weeks I will be delivering batches of raw sales figures that must end up in an error-free, well-structured Excel workbook. Every number needs...
Read moreAccurate Sales Data Entry & Reports - 24/09/2025 11:57 EDT
Over the next two weeks I will be delivering batches of raw sales figures that must end up in an error-free, well-structured Excel workbook. Every number needs...
Read moreOptimize Logistics via Excel Spreadsheet
Excel Optimization Spreadsheet for Logistics Company I need a professional Excel-based solution to optimize and manage my logistics operations. Key requirements...
Read moreAccurate Sales Data Entry & Reports - 24/09/2025 08:56 EDT
Over the next two weeks I will be delivering batches of raw sales figures that must end up in an error-free, well-structured Excel workbook. Every number needs...
Read moreMatrix Price List Conversion
I have roughly 4,000 SKUs sitting in a matrix-style spreadsheet (one part number spread across many columns and rows). I need everything reshaped into a clean,...
Read moreExcel Image Filename Updater
I have an Excel workbook that lists hundreds of product names next to an alphanumeric code that matches the current filenames of their images (e.g., “A17BX.jpg”...
Read moreCustom Advanced Excel Formulas
I need a power-user to transform several workbooks by replacing my patchwork of manual entries with robust, well-documented formulas. Array logic, dynamic range...
Read moreExcel Journal with ROI and Macros
I need an Excel journal that journals all my option trades and calculates monthly ROI automatically. This journal should include: - Monthly ROI calculations - A...
Read moreExcel Overhaul & Automation Needed
My current Excel workbook has grown messy and unreliable, so I need it taken back to a clean, efficient state. Every sheet must be reviewed for three key areas:...
Read moreAccurate Excel Manual Data Entry - 23/09/2025 11:52 EDT
I have a collection of digital records—mainly Excel spreadsheets, with the occasional Word file—that must be copied, organized, and double-checked inside new Ex...
Read moreAdvanced Excel Formula Development -- 2
I have an Excel workbook that is growing in size and complexity, and I’m hitting the limits of my own formula skills. I need a specialist who can design and imp...
Read moreExcel 2007 VBA Lookup Tool
I’m working with a workbook that has three core sheets right now: Sheet 2 holds roughly 95,000 part-number records, Sheet 3 another 100 new or updated parts, an...
Read moreExcel Multi-Select Dropdown Setup
I have an existing Excel workbook and I want to enhance it with a true multi-select dropdown list—something users can click once and then pick multiple values t...
Read moreExcel Multi-Select Dropdown Creation
I need an Excel expert to create multiple multi-select dropdown menus across four Excel documents. The text options for the dropdowns should be organized exactl...
Read moreExcel VBA Statistical Reporting Automation
I need a clean, well-structured VBA routine that will take raw data sitting in multiple Excel worksheets, run the required statistical analysis, and return an e...
Read moreExcel Data Entry Input
I need a reliable freelancer to help me populate Excel spreadsheets with raw data I supply. The assignment is 100 % data input—no analysis, formulas, or report-...
Read moreExcel Sales & Incentive Workbook
I need an Excel-based workbook that takes the daily sales data, employee performance metrics, and expense reports we collect across the company and turns them i...
Read moreQuick Excel Formatting Fix
I have a single Excel workbook that only needs a tidy-up. The task is straightforward: set each column to an appropriate width, auto-fit all row heights so text...
Read moreExcel Data Entry & Validation
I have a collection of mixed data—numbers and text—that needs to come together in one well-organized Excel workbook. The information will arrive from three dire...
Read moreOptimize Sheets Automation Formulas
My current Excel and Google Sheets files already run a set of automations, but the formulas behind them have grown slow and increasingly fragile. I need someone...
Read moreOrganize Mixed Excel Data
I have an Excel workbook filled with rows that combine text and numeric fields, and it has become unwieldy. Your task is straight-forward: sort and organize thi...
Read moreEmergency Excel VBA Repair
My workbook relies on a VBA routine that pushes data from one sheet to another with VLOOKUP / INDEX-MATCH logic, but the macro has suddenly stopped running. No...
Read moreDevelop an Excel Plug-in to create Member Verification / Paid Account Access to Workbook
I'm creating Excel files that I want to distribute but have really good control over access. Is that possible beyond just simple Excel password protection. Exce...
Read moreExcel Customer Data Administrator
I need an experienced hand to take full charge of our customer data in Microsoft Excel. The job starts with entering new records and updating existing ones, mov...
Read moreExcel Contract Management Dashboard
I manage three service contracts—vehicle, clothing, and travel—and need a single, customizable dashboard in Excel that consolidates everything in one place. The...
Read moreExact Excel Replication with Formulas
I have a set of attached documents that mix detailed tables with accompanying text lists. I need every page rebuilt in Microsoft Excel so it looks and behaves e...
Read moreExcel Comments Consolidation by Category
I have one Excel workbook that already holds several sheets of raw comment data. What I need is a clean, automated way to re-organise everything so the final fi...
Read moreTabla Comparativa de Precios Excel
Necesito convertir varias cotizaciones de suministro para una obra en una única tabla comparativa clara y fácil de actualizar. El resultado debe ser un archivo...
Read more