Visual Basic Jobs

I have a spreadsheet whose dates now appear in a mix of styles—some show “12/05/23”, others “05-12-2023”, a few are stored as text strings, and a handful are genuine serial numbers. I need the whole column cleaned so every entry follows one consistent, true-date format that Excel recognises natively. Your task is strictly data cleaning: standardise every date, verify the change with a quick formula check (COUNT, MIN, MAX—whatever you prefer), and hand back a file that requires no manual fixes from me. Feel free to tap Power Query, formula tricks, or simple formatting commands; I only care that the resulting dates sort, filter, and calculate correctly. Deliverables • The cleaned workbook with a single, uniform date format (I’m happy with yy...

Necesito crear cinco libros de Excel orientados a presupuestos y finanzas. Quiero una solución de complejidad intermedia: lo bastante robusta para seguir ingresos y gastos en detalle, pero aún fácil de entender para usuarios sin perfil técnico. Alcance general • Cada libro cubrirá un área distinta (operaciones, marketing, recursos humanos, inversiones y flujo de caja). • Las hojas deberán estar organizadas por secciones de captura, cálculo y reporte, con celdas protegidas donde convenga. • Incluiré datos de ejemplo; tú ajustarás fórmulas y estructura para que, al sustituirlos, todo se actualice automáticamente. Requisitos técnicos • Formulación avanzada: BUSCAR...

I need a straightforward yet robust system that keeps my product inventory accurate the moment something is sold, returned, or moved. Real-time tracking is essential—I should see current stock, incoming shipments, and low-stock alerts without waiting for a manual refresh. Equally important, I want meaningful reporting and analytics: sales velocity, turnover rate, and historical trends that I can export to CSV or view in clear dashboards. I’m flexible on whether this is a web app, desktop build, or even a hybrid solution; pitch what you believe is the best fit for reliability and ease of use. If barcode scanning or other advanced features can be added without over-complicating the workflow, let me know—they’re not mandatory but could be a bonus. Deliverables I expe...

I need an Excel spreadsheet to track data on people, the number of pieces they handle, and any mistakes they make. It should include: - Data entry forms for easy input - Error tracking (method flexible) - Automated calculations Ideal skills and experience: - Proficiency in Excel - Experience in creating user-friendly data entry forms - Strong understanding of error tracking methods and automated calculations

I have a set of spreadsheets that simply need accurate, fast data entry. The worksheets are already structured in Excel; I only need you to key in the information I provide—both numbers and text—in the correct cells. No formulas, charts, data-validation rules, or error-checking routines are necessary on your side; everything is prepared so you can focus on getting the mixed data in place without altering the existing layout. Please be comfortable working with large Excel files and following clear naming conventions for sheets and columns. I will supply the source documents and a brief guide so you know exactly where each field belongs. Once finished, return the updated workbook so I can run my own in-house checks. That’s the entire scope: reliable data entry, delivered ...

I have a set of spreadsheets that simply need accurate, fast data entry. The worksheets are already structured in Excel; I only need you to key in the information I provide—both numbers and text—in the correct cells. No formulas, charts, data-validation rules, or error-checking routines are necessary on your side; everything is prepared so you can focus on getting the mixed data in place without altering the existing layout. Please be comfortable working with large Excel files and following clear naming conventions for sheets and columns. I will supply the source documents and a brief guide so you know exactly where each field belongs. Once finished, return the updated workbook so I can run my own in-house checks. That’s the entire scope: reliable data entry, delivered ...

I have a raw customer information dump that needs to be cleaned up and structured in a single Excel workbook. The spreadsheet must include the following fields for each record: • Name and address • Email and phone number Once the data is validated and entered, I want every row assigned to a clear category column that identifies the customer type, so the final sheet can be quickly filtered or reported on. Simple Excel formulas such as CONCAT, TRIM, and basic IF statements should be used where they save time and improve consistency; however, there is no need for advanced macros or VBA. Accuracy is critical—I will be cross-checking a sample of the finished data before sign-off—so please double-check spellings, spacing, and the integrity of any formulas you add. I&...

I have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

I have about 350 scanned images containing mixed content—text, numbers and a few special symbols—that need to be transferred into my pre-formatted Excel sheet. You may run the images through your preferred OCR tool, but every field must then be checked by eye and corrected so the final spreadsheet is 100 % true to the originals. No fancy cell styling or formulas are needed; plain text and numbers in the right columns are all I’m after. I will supply: • A zipped folder of the images • A sample workbook that shows the column order and naming convention Your deliverable is a single Excel file (or compatible Google Sheet) populated with all records and saved in XLSX format. If this first batch is completed accurately and on schedule, I’ll have similar sets...

Project Title: Interactive DOT Inspection Dashboard & Safety Analytics Tool ​Overview: with specific Metrixx and kpi sop's I am looking for a skilled Excel or Google Sheets expert to build a clean, automated dashboard to track our DOT inspection data. The goal is to turn our routine inspection reports into a professional visual presentation that helps us improve our FMCSA safety scores. This is a straightforward project for someone comfortable with Pivot Tables, Slicers, and basic data visualization. ​1. Data Structure (The Setup) ​The tool needs a "Raw Data" tab where I can simply paste my inspection exports. The dashboard should then automatically categorize and filter by: ​Units: Unit 1 (Tractor), Unit 2 (Trailer), and Unit D (Dolly). ​Personnel: Driver Name and Drive...

I am building a state-of-the-art, full-projection dome that lets visitors step inside India’s most spectacular cultural and spiritual gatherings. Your task is to create the immersive “digital twin” content that will wrap the entire 360-degree surface, play back flawlessly, and captivate an audience that simply sits back and watches. The experience is intentionally low on interactivity—once the show starts, it should run on its own—so every creative decision must emphasise cinematic storytelling, photoreal visuals, and enveloping spatial audio rather than user-driven controls. Think of it as a living documentary projected on a seamless sky. You may choose the best production pipeline—8K 360° video capture, photogrammetry, volumetric scans, Unreal ...

I'm seeking an Excel expert to resolve AUTOMATION ERROS! errors in my spreadsheet. The cells involved contain a mix of text, numbers, and dates. Ideal Skills & Experience: - Proficient in Excel formulas and error troubleshooting - Experience with handling data types: text, numbers, and dates - Attention to detail and problem-solving skills Please provide examples of similar work done.

I have a collection of Excel and CSV files that need to be consolidated, reviewed, and cleaned so they are ready for analysis and reporting. The raw sheets contain blank cells, occasional typos, inconsistent date and number formats, and some possible duplicate records. **Scope of Work** * Consolidate multiple Excel/CSV files into a single organized workbook. * Enter missing rows or columns based on scanned notes that I will provide (images or PDFs). * Review and correct obvious spelling mistakes and numeric errors. * Standardize formats across all columns (dates, currency values, percentages, etc.). * Identify and remove duplicate records while preserving the most complete or first valid entry. * Ensure the final dataset is accurate, clean, and ready for analysis. **Deliverables** 1. ...

I have a collection of Excel/CSV files that need to be consolidated, checked, and polished so they are ready for analysis and reporting. The raw sheets contain a mix of blank cells, occasional typos, uneven date and number formats, and some possible duplicate records. Your job is to: • Enter any missing rows or columns from scanned notes I will supply as images or PDFs. • Review every field, correcting obvious spelling or numeric errors. • Standardize dates, currencies, percentages, and other formats so each column is consistent throughout the workbook. • De-duplicate the data while preserving the first complete record when matches appear. • Return a single, clean Excel file plus the original, unaltered copy for reference. I’ll share the files...

Necesito una macro para CorelDRAW que tome los vectores y grupos de objetos que yo seleccione y los reubique dentro de un rectángulo que yo mismo defina, aprovechando al máximo el espacio disponible sin que se superpongan. Requisitos clave • Funcione con vectores y grupos de objetos de cualquier tamaño. • Pida o permita introducir las dimensiones del área destino. • Calcule automáticamente la mejor distribución posible (similar a un “auto-nesting”), manteniendo proporciones. • Respete un margen configurable entre objetos y, de ser posible, permita rotación a 90° para ganar espacio. • Interfaz sencilla: botón o acceso directo dentro de CorelDRAW para ejecutar la orden en un solo paso. ...

I need a streamlined VBA-driven workflow in Excel that lets me handle all incoming payroll data quickly and error-free, then produce a clean summary at the click of a button. The workbook must support three core activities: 1. Data entry – A simple userform for typing in one-off adjustments or new employee lines. 2. Data importing – A macro that pulls in weekly CSV exports from our time-clock system, places them in the right tables, and maps every column automatically. 3. Data validation – Rules that flag duplicate employee IDs, detect missing dates or rates, and stop bad records before they pollute the file. Once the data is in place and passes validation, I want a single “Generate Summary” control that produces an easy-to-read payroll summary (emplo...

Saya memiliki dataset Excel berisi data peternakan dan ingin mengubahnya menjadi dashboard interaktif yang selalu menampilkan informasi terkini. Ruang lingkup: • Bangun dashboard yang terhubung langsung ke file Excel sekaligus menulis data itu ke database terpusat, sehingga setiap penambahan atau perubahan di file otomatis tercermin di visualisasi. • Tampilkan semua informasi Dokumentasi: Saya butuh catatan langkah-demi-langkah (setup database, koneksi, transformasi, pembuatan grafik, dll). Kriteria penerimaan: 1. Dashboard berfungsi penuh secara interaktif yang memuat semua informasi dari dataset. 2. Data otomatis ter-update ketika file Excel berubah. 3. Dokumen proses lengkap beserta screenshot atau rekaman singkat.

I need a single Excel workbook that lets my office staff, most of whom have only basic spreadsheet skills, run every day-to-day aspect of our small manufacturing unit. We make roughly 15–20 different products and I want each batch, sale, return, purchase, expense and salary entry captured in one place, then automatically summarised for quick decision-making alongside a convert to json (for single entry or the entries that we select or per day so that we can have a file that is ready to be uploaded on tally as well) and all the sheets of the work book should be interconnected so that we dont have to enter a single entry multiple times Core flow • A simple “daily entry” interface where staff can pick the date, choose the item, state quantities produced, sold or retu...

I have several PDFs that contain text-only tables, but the layout changes from page to page. I need every piece of text moved accurately into a live Google Sheet, preserving each table’s logical order even when the columns or row counts shift. You will open each PDF, examine the table format, and enter the information into a shared Google Sheet I’ll provide. When a table differs, create or adjust columns so every data point still lands in a clear, searchable spot. Consistency inside the sheet matters more than mirroring the visual look of the original. Deliverables • One Google Sheet, fully populated and neatly formatted • No missing fields or merged-cell artifacts • A brief note flagging any source pages that were unreadable or ambiguous I’ll ...

I want to make education video of history for competitive exams in way of cinematic story telling with visuals ,map animations and AI character talking . For that I have to make 20-25 videos each of length 30 minute

I have several batches of information that must be keyed by hand into a pre-formatted Excel workbook. The source files arrive as scanned PDFs and JPGs, and total roughly 3,000 rows per batch. Because everything is entered manually, accuracy is more important than speed: each field has to match the scan exactly, follow the column order I supply, and respect the simple drop-down validations already built into the sheet. Once the file is complete, run a quick spell-check and verify any numerical columns with the SUM I include at the bottom—no formulas or macros beyond that are required. I’ll deliver Batch 1 as soon as we start; if the quality is above 99 % there will be additional batches ready straight after. Deliverables • Finished .xlsx file for Batch 1, fully populate...

I already have a working Excel workbook in daily use, but its current macros are slow, brittle, and hard to maintain. I need an experienced VBA developer to dive into the existing code, streamline the logic, and add any missing functionality so routine tasks run reliably at the click of a button. Although the immediate scope is limited to Excel, I would like the code written cleanly enough that it could later be adapted for Access or Word–based reporting if the project grows. After an initial review of the file, we can agree on the exact touch-points, but my priorities are: • Refactor or replace outdated VBA modules • Optimise speed and eliminate manual steps wherever possible • Add clear in-line comments and a brief user guide sheet • Leave the workbook f...

I need to embed practical AI features directly inside Outlook, Word, and Excel so my day-to-day work becomes far less manual. Primary goals • Tame email overload in Outlook by automatically triaging, categorising, flagging priorities, and suggesting quick replies. • Speed up document creation in Word with smart templates, content suggestions, and live error-spotting that adapts to our writing style. • Simplify scheduling and calendar management across the suite—auto-generate meeting slots, resolve conflicts, and surface insights on time allocation. Key capabilities to build – Automation of repetitive tasks: rules or add-ins that run without constant supervision. – Data analysis & insights: lightweight dashboards or side-panes inside Exce...

I want a single Excel file that lets me drop in fresh sales and purchase data and instantly see what’s happening in the business. The heart of the job is an interactive dashboard—clean, professional, and easy for anyone on my team to grasp at a glance. Here is what I need the file to do: • Automatically refresh whenever I upload a new data file, so no manual copy-pasting. • Display bar, line, and pie charts that highlight both sales trends and purchase trends. • Use pivot tables and slicers to let me drill down by product, date, or supplier without breaking the layout. • Track current inventory levels in real time, flagging low-stock items. • Surface the two KPIs I care about most—product-wise performance and overall revenue growth&mdas...

I have several PDFs that contain text-only tables, but the layout changes from page to page. I need every piece of text moved accurately into a live Google Sheet, preserving each table’s logical order even when the columns or row counts shift. You will open each PDF, examine the table format, and enter the information into a shared Google Sheet I’ll provide. When a table differs, create or adjust columns so every data point still lands in a clear, searchable spot. Consistency inside the sheet matters more than mirroring the visual look of the original. Deliverables • One Google Sheet, fully populated and neatly formatted • No missing fields or merged-cell artifacts • A brief note flagging any source pages that were unreadable or ambiguous I’ll ...

I need an Excel dashboard to analyze my sales and purchase data. The dashboard should provide insights on sales trends, purchase trends, and inventory levels. Requirements: - Visual elements: charts, graphs, tables, and pivot tables - Periodic data updates Ideal Skills and Experience: - Proficiency in Excel, especially in creating dashboards - Experience with data visualization - Ability to set up periodic data updates Looking forward to your proposals!

I want to keep my order tracking lightweight, so I’d like the entire solution built in a spreadsheet environment (Google Sheets or Excel—whichever you’re fastest with). Users will open a clean form-style interface, fill in customer details, product, quantity, price, and hit “Submit.” Those entries should drop into a master table behind the scenes without exposing formulas or letting anyone accidentally overwrite data. From that same file I also need a concise dashboard or pivot-style report that totals sales by day, week, and product so I can spot trends at a glance. Because all data will be typed in manually, the form must include basic validation (no blank mandatory fields, numeric checks on quantity/price, date picker, etc.) to keep everything consistent. ...

I have three Excel workbooks whose VBA-driven macros used to handle a handful of quick calculations and automated steps for my students. Those functions have stopped running altogether—no errors, just macros that refuse to fire—so first I need the existing code reviewed, debugged, and restored to full working order. Once everything works flawlessly in Excel, the same functionality has to live inside Google Sheets. After you tidy up the VBA, please translate it into clean, well-commented Google Apps Script, embed it in a Sheets copy of each file, and make sure the buttons or menu items behave exactly as they do on the desktop. Deliverables • Repaired VBA across the three original worksheets • Change log or in-line comments explaining what you fixed • Google ...

I’m refreshing my website and need clear, easy-going copy that simply tells visitors who we are, what we do, and why they should stick around. The sole purpose is to provide information—no hard-selling tactics—so the wording should feel conversational yet still reflect our professionalism. Here’s what I’m after: • Complete website copy, ready to paste into each page (Home, About, Services, and Contact are the core sections I have in mind). • A consistent, casual tone of voice throughout, free of jargon and heavy marketing language. • Naturally placed keywords that help with basic on-page SEO without sounding forced. • Brief calls to action that guide readers to learn more or get in touch rather than “buy now.” I&rsquo...

I need an Excel expert to fix formula errors in my resource management workbook. One worksheet isn't correctly pulling hours required by employee type from other sheets. Requirements: - Excel proficiency - Experience with complex formulas - Problem-solving skills Please provide relevant experience in your application.

I need assistance installing Visual Studio 2022 on Windows 11 and creating an MSI installer for it. I am a Visual Basic developer, but have hit a problem creating an installer and would like some assistance/guidance. I recently updated the application to use Nuget packages and Net 8.0 and am struggling getting the dlls to install correctly. The VS installation creator is picking up the wrong sql server and system dlls. The application includes two extensions, Component One and DevExpress I suspect the problem might be because the extensions are using different versions of the system and sql server dlls. Is this something you can help with please? Requirements: - Create an MSI installer for the setup of a desktop application Ideal Skills: - Experience with Visual Studio 2022 and Ne...

The task is to build an interactive Power BI dashboard that visualises my organisation’s consumption volume. All data sits in a set of Excel spreadsheets and must stay synced automatically, so the model should refresh cleanly whenever new files overwrite the existing ones. Key focus • Showcase yearly comparisons of total consumption, with clear visuals that allow users to spot growth, decline, and outliers at a glance. • Simple slicers or filters for year, product line, and region (the columns are already present in the source files). • A clean layout that can be shared through the Power BI service without additional configuration on my side. Data • Excel workbooks reside in a OneDrive folder; Power BI should connect directly to that location to preserve the...

I need an extra set of hands to move a collection of mixed text-and-number records into an Excel workbook and make sure every piece of text ends up neatly grouped by category. Accuracy matters: totals and numerical fields must stay intact, and the category labels should be applied consistently so I can sort, filter, and pivot the sheet without additional clean-up. The source files are ready; you will receive a brief legend explaining each category as well as the column layout I already use for similar jobs. If you have suggestions for small improvements—conditional formatting, simple validation rules, or a more efficient way to separate the categories—feel free to propose them, but my priority is getting a reliable, well-structured file back quickly. Deliverables • Compl...

I have several PDFs that contain text-only tables, but the layout changes from page to page. I need every piece of text moved accurately into a live Google Sheet, preserving each table’s logical order even when the columns or row counts shift. You will open each PDF, examine the table format, and enter the information into a shared Google Sheet I’ll provide. When a table differs, create or adjust columns so every data point still lands in a clear, searchable spot. Consistency inside the sheet matters more than mirroring the visual look of the original. Deliverables • One Google Sheet, fully populated and neatly formatted • No missing fields or merged-cell artifacts • A brief note flagging any source pages that were unreadable or ambiguous I’ll ...

I need a Google Sheet tailored for fast, reliable entry and storage of my financial figures. The layout should guide anyone on the team to type or paste numbers without breaking anything, then automatically calculate running totals, percentages, and other basic metrics. Here is what I am looking for: • Robust formulas and calculations that update instantly as new rows are added. • Thoughtful data-validation rules—drop-downs, date pickers, and error messages—to keep the dataset clean. • Clear conditional formatting that flags missing inputs, out-of-range numbers, or any anomalies at a glance. The finished file must sit in Google Drive, work with standard Google Sheets functions only (no add-ons), and be easy for me to extend later. A brief note inside the...

I need help with the following problems on this Excel sheet attached. Thank you! Ideal skills and experience: - Proficiency in Excel, especially for beginners - Strong understanding of supply chain concepts - Ability to teach calculation of bias, RMSE, and MAD - Experience in the retail industry

I manage a driving school and do weekly payroll calculations for driving instructors. I need a clean, reusable Excel workbook that lets me log regular and overtime hours alongside work-related costs (gas receipts with mileage), and any bonuses earned for each driving instructor (employee). The sheet should automatically roll these daily entries into clear weekly totals, then feed monthly and yearly summaries so I can see trends at a glance without extra work. If you find a simple way to leave space for other cost or earnings categories (bonuses earned) that would be a plus. Core requirements • Input section for each instructor would be Name, Dates of Pay, Regular Hours, Overtime Hours, Regular Pay Rate, OT Pay Rate, Gas Expenses, Mileage, Average MPG, Cost/Mile, Miles Driven...

I need a clean, easy-to-update daily sales scorecard built in Excel. The file should let me enter each day’s numbers and instantly see my performance at a glance—totals, averages, simple charts, whatever you feel best communicates results. Please set up formulas so I don’t have to touch any calculations; my role is just to drop in raw figures and read the insights. Structure is flexible as long as it stays in one worksheet or a logically linked set of tabs, but I do want space to expand later if I decide to track weekly or monthly summaries. Clear labeling, consistent formatting and a visually tidy layout are essential. Deliverable: an unlocked Excel workbook ready for daily use, with a brief note explaining any key formulas or pivot tables you add so I can maintain it ...

I need help transferring a set of mixed text and numerical records into a clean, well-structured Excel spreadsheet. Everything will be keyed in manually—no file imports or automated scripts—so attention to detail and fast, accurate typing are essential. Scope of work: • Enter each record exactly as provided, preserving capitalization, punctuation, and numeric precision. • Follow my column order and any cell-formatting notes I supply. • Double-check for typos, missing fields, and consistent data types. • Deliver the finished .xlsx file plus a brief summary of any issues or ambiguities you encountered. I’ll share the source documents and a template as soon as we start. If you’re comfortable with Excel functions like basic validation and con...

I have an existing spreadsheet and I need you to build a clean, reusable formula that adds a percentage-based margin across several columns at once. The goal is simple: each product cost already in the sheet should automatically display its selling price after the margin is applied, and any future rows I add must calculate correctly without extra work on my part. You’ll receive the workbook as it is now, along with the exact percentage I use. Please set up the formulas (or structured table columns, if that’s the most robust route) and test them so I can drop in new cost figures and instantly see the margin-adjusted numbers in every specified column. Deliverables: • Updated Excel file with the margin formula in place for all required columns • A brief note or comme...

I need day-to-day administrative help with a clear priority on document organization. Every file, contract, invoice, and note must live where it can be found in seconds—both online and in a small physical archive that is already on-site. You will set up and maintain a logical folder hierarchy in Google Workspace and Microsoft Office, then mirror that structure in whichever other document management system we agree on so there is one source of truth. While document control is the centerpiece, the role also folds in classic admin work. My calendar needs steady upkeep, routine meetings should be booked without overlaps, and the shared inbox has to be screened so only the essential messages reach me. A quick, courteous reply to basic enquiries keeps everything moving. Data tracking sit...

I have a stack of physical documents that need to be keyed into a single, well-organized Excel workbook. The pages contain a mix of numbers and text—product codes alongside descriptions, quantities next to notes—so careful attention to detail is essential. Your task is straightforward: read each page, transfer every data point into the appropriate column, and keep the layout clear and consistent. I’m not asking for complex formulas or macros; accuracy, speed and consistent formatting (clean column headings, uniform fonts, correct number/date formats) are what matter most. Once you’re done, I should be able to open the file and immediately filter, sort or run simple calculations without hunting for mis-typed entries. If something on a page is illegible, flag it...

I have an Excel workbook that takes a single monthly CSV/Excel file and automatically feeds five KPI-driven tabs, each packed with charts that our individual outlets currently open with their own password. It works, but juggling versions and macros is becoming painful. I want the same experience delivered through an app my colleagues can launch from their browsers or, if they prefer, install on their Windows PCs—ideally the codebase is shared so maintenance stays simple. Core needs • Replicate every chart and metric already in the spreadsheet, keeping the five-tab structure so users immediately recognise their numbers. • Secure, outlet-specific access: each location must log in and see only its own data (mirroring today’s password segregation). • Simple mo...

I’m looking for a clean, well-structured Excel workbook that lets me enter sales figures and all associated costs, then instantly see my profit margins at a glance. Detailed calculations are essential, so every figure—from gross to net margin—should flow automatically from clear, auditable formulas. The file should include: • An input area where I can add or update revenue and expense data without breaking the model. • Formula-driven summaries that display total income, total costs, gross profit, net profit, and margin percentages. • A calculation sheet that performs the heavier analytical work (break-even points, sensitivity toggles, growth comparisons, or any other routine you recommend for deep-dive profitability checks). • A tidy dashboard...

I have a single Excel file holding fewer than 1,000 rows of mixed text and numeric fields. My aim is to identify and flag records that are not exact duplicates but close enough to be considered the same customer, product, or transaction. In other words, I need a reliable fuzzy-matching solution that surfaces these near-matches so I can review and consolidate them. Here is what I need from you: • A working Excel-based approach—formulas, Power Query, VBA, or a combination—that compares the mixed fields and returns a similarity score or direct match flag. • Clear, editable logic so I can tweak thresholds or add new columns later without rewriting the whole thing. • A brief walkthrough (written notes or short screen capture) showing how the matching was set up ...

I keep all of my renewal data in a single Excel workbook, and every time I need to review information for a specific customer I have to re-apply filters manually. I want that entire routine collapsed into a single click. Here’s what I need: a lightweight automation—VBA, Power Query, or another native Excel approach—that sits inside the file and instantly filters the renewal dataset by customer whenever I press a button or choose a custom ribbon command. The solution must work in standard desktop Excel (Microsoft 365), recognise new rows automatically as the table grows, and preserve any existing formulas and pivot tables. Please deliver a working, macro-enabled version of the workbook (or a clearly commented code module I can import) along with a short set of instructio...

I have a set of raw survey results that I need prepared for deeper analysis. The core task is data cleaning inside Excel: removing duplicates, handling blank or inconsistent entries, normalizing date or rating formats, and making sure every column is analysis-ready. Once the file is cleaned I should be able to drop it straight into pivot tables or statistical add-ins without further fixes. Please keep all original fields intact, add a clearly labeled “Cleaned” worksheet, and document any transformation rules you apply in a small notes tab so I can audit or tweak them later. If you have VBA routines, Power Query tricks, or other proven Excel techniques that speed up repeat cleaning, feel free to use them—the deliverable just needs to stay within the Excel environment...

I need a clean, professional-looking project quote sheet that I can hand to clients with confidence. At a minimum it must capture a clear cost breakdown alongside basic client details, laid out so the numbers and contact information are easy to digest at a glance. I’m undecided on whether the final file should remain locked in a fixed-format PDF or stay fully editable (Excel, Google Sheets, or a fillable PDF are all possibilities), so I’d value your guidance on the pros and cons before we lock that in. If you think adding a project-timeline block would round things out, feel free to suggest it; the core priority is the cost and client sections. need to have a drop down list of materials, and Labour , need to have a editable material list that is locked, but can be easily ...

I need a clean, well-structured Excel file that will hold and organise my financial data. The workbook should be laid out so new entries flow in exactly where they belong and key numbers update automatically. On top of that, I want each record created through my Google Form to be pulled into the sheet and, when required, merged into a Word document template for easy printing or sharing. Here’s the flow I have in mind: • A Google Form captures the raw financial inputs. • Responses are sent straight into the Excel workbook (or a synced Google Sheet that feeds the workbook). • With one click, a macro or script places the chosen record into a pre-formatted Word file—totals, dates, notes and all—ready for download or email. The final deliverable is the f...

I need an experienced Excel expert to fine-tune my workbook used for data analysis, specifically for generating skill completion reports. The goal is to eliminate any bugs and ensure its long-term reliability. Key Tasks: - Debugging existing formulas and functions - Streamlining report generation processes - Ensuring data integrity and accuracy Ideal Skills and Experience: - Proficiency in Excel, especially in data analysis - Experience with report generation and complex formulas - Attention to detail and problem-solving skills Looking for someone who can deliver a robust and efficient Excel workbook.