Excel 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 more
ID / Date
Listing
Link
Excel 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 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 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 moreINTEGRER UNE API SUR UN GOOGLE SHEET
JUSTE INTEGRER UNE API SUR UN GOOGLE SHEET
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 moreExecutive summary management
I have a collection of source documents that must be transferred into my Excel template exactly as specified. The job is pure data input—no complex formulas, no...
Read moreExecutive summary management
I have a collection of source documents that must be transferred into my Excel template exactly as specified. The job is pure data input—no complex formulas, no...
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 moreExcel Power Query Table Creation
Please help me in making the power query table in excel based on the following information. Attached excel file have three tabs named PMS Data, TRXCDE and CAT P...
Read moreNumeric Dataset Cleaning & Standardization
I’m looking for swift, accurate help tidying up a numeric dataset. The file contains a mixture of duplicate rows, gaps, and inconsistent number formats that are...
Read moreCreate Book Cover according to Amazon Specifications
I want someone to create the book cover for the paperback edition of the book. The ebook cover is already there. Something similar would be good unless someone...
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 moreExcel Data Analysis Enhancement
I need help refining my Excel spreadsheet for data analysis. Currently, I use it primarily for data analysis, and I need assistance specifically with pivot tabl...
Read moreFlightRadar24 / FlightAware API Integration to Flight Schedule Board .xlsm
I have a macro-enabled workbook, Flight Schedule Board.xlsm, that currently relies on manual entry. I want it to pull live flight information directly through a...
Read moreLegacy Excel VBA Code Audit
I have a large, business-critical Excel workbook that relies on old-school VBA macros. The original author is long gone, so before I touch anything I need a cle...
Read moreAutomate Excel Lookup Formulas
The task is to populate an Excel workbook with robust VLOOKUP or HLOOKUP formulas that draw live data from an online database I provide. All raw figures sit in...
Read morePrecise Excel Data Input
I have a collection of source documents that must be transferred into my Excel template exactly as specified. The job is pure data input—no complex formulas, no...
Read moreExecutive summary management
I have a collection of source documents that must be transferred into my Excel template exactly as specified. The job is pure data input—no complex formulas, 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 Macros & Hyperlink Fixes
I have two Excel workbooks that need quick, precise VBA work. In the first workbook you’ll revisit the hyperlink-editing macro you built for me earlier. It curr...
Read moreDynamic Salary & Expense Tracker
I need to update my current excel sheets to be more robust in order to allow useful business decisions 1. I need 4 Excel workbook that can do things seamlessly:...
Read moreCorporate One-Page Excel Template
We are in need of a one page excel template. Please see the attached one page sample. We already have a excel workbook with data, so we need this one-page excel...
Read moreExcel Multi-User Inventory System
I need a robust Excel-based solution that lets several team members work simultaneously with our inventory data. The core of the workbook must handle complete o...
Read morePrecise Excel Data Input
I have a collection of source documents that must be transferred into my Excel template exactly as specified. The job is pure data input—no complex formulas, no...
Read moreInvoice Receipt Excel Entry
I have a stack of physical invoices and receipts that need to be converted into a clean, well-structured Excel spreadsheet. I will supply high-resolution scans...
Read moreExcel One-Page Engineering Template
I have an existing workbook that feeds an engineering report, and I now need a single-page template that can be dropped in, pull the right cells, and present th...
Read moreExcel Expert Needed for Various Tasks -- 2
I'm seeking a skilled Excel expert to assist with a variety of tasks. While I haven't specified the exact nature of the work, it may involve data entry, organiz...
Read moreEducational Outreach & Record Reformatting
I have two parallel tasks that need to move forward together. First, a series of requests have already been submitted to various educational institutions. I nee...
Read moreExcel expert who can create Live Planner, Gantt charts, tracking systems
I need an excel expert who can create a live planner, Gantt charts, tracking reports, project management, etc in excel. Please apply if you already have experie...
Read moreFarm Excel to Windows Software
I currently run all of my farm’s accounting and operational records in a single Excel workbook. The file has grown so complex that it now needs to live inside a...
Read moreUnbreakable VBA Code Protection Required
I'm looking to protect my VBA codes with a method or software that makes them completely unbreakable against piracy. I want the code to remain in the same VBA t...
Read moreExcel Automation & Data Management
I’m looking to turn my day-to-day Excel workload into a streamlined, largely automated system. The priority is to remove the manual effort from complex calculat...
Read more