Excel VBA Jobs

I have a sales performance sheet. I want an experienced person who is specialized in advanced Excel formulas and who can automate the sheet. The sheet is already automated. Some of the formulas are not working, and I want to add some more stuff into it, so I need someone who can actually do the stuff.

Hi there! Fixed budget & Looking for resonable canditade allowed! I need to streamline a recurring data-analysis routine that currently takes me hours of manual work each week. The raw data arrives in several worksheets and, from there, I want one clean, automated flow that: • pulls the latest dumps into a master sheet • applies dynamic formulas and functions to flag key metrics, spot variances, and summarise totals automatically • refreshes itself with a single click so I can hand the file to colleagues with zero additional steps Formulas and functions sit at the core of this job. If you decide that a few pivot tables or quick charts would clarify the insights, I’m open to that, but the heavy lifting must happen through well-structured formulas that are easy to...

Complete Excel-Based Business Record Management System I need a complete Excel-based business management system to maintain all daily business records in a professional and organized way. The file should be user-friendly, automated, and easy to manage. The system should include the following modules: 1. Customer Ledger Customer Name Contact Number City Opening Balance Debit / Credit Entries Outstanding Balance Customer Transaction History 2. Supplier Ledger Supplier Name Purchase Records Payment Records Remaining Payable Amount Supplier History 3. Stock / Inventory Management Item Name SKU Code Stock In / Stock Out Current Available Stock Purchase Price Sale Price Low Stock Alert 4. Expense Management Daily Expenses Expense Categories Cash Expenses Monthly Expense Summary 5. Bank & C...

So this is the task. There is a look up of different cities Tampa, Pune, Chennai etc. I place people across Jan to Dec and it should calculate the net cost. If total cost is more than allowed total, then turn the cells P2 - P5 red. If less than, turn blue. If equal, turn is: green.

Project Title Complete Excel-Based Business Record Management System Project Description I need a complete Excel-based business management system to maintain all daily business records in a professional and organized way. The file should be user-friendly, automated, and easy to manage. The system should include the following modules: 1. Customer Ledger Customer Name Contact Number City Opening Balance Debit / Credit Entries Outstanding Balance Customer Transaction History 2. Supplier Ledger Supplier Name Purchase Records Payment Records Remaining Payable Amount Supplier History 3. Stock / Inventory Management Item Name SKU Code Stock In / Stock Out Current Available Stock Purchase Price Sale Price Low Stock Alert 4. Expense Management Daily Expenses Expense Categories Cash Expenses Mo...

My phone book currently lives in a single .xlsx file and holds about 200,000 records. I need that sheet cleaned and standardised in two key ways: 1. Every duplicate number—regardless of whether it carries the +91 prefix or not—must be identified and removed so each contact appears only once. 2. Phone numbers must carry a consistent format for the Indian market. That means adding or stripping “+91” wherever required so each final entry follows one clear rule (I’m happy to agree on the exact rule with you before you start so we’re on the same page). The end result I’m after is a fresh Excel workbook with: • Zero duplicate rows • Uniformly formatted mobile numbers • No broken formulas, blank rows or stray characters If you ...

I need a detailed comparison between purchase orders and acknowledgements. The task involves identifying discrepancies in several areas: Discrepancy Types: - Line item discrepancies - Quantity discrepancies - Price discrepancies - Line numbers and descriptions may not match exactly Ideal Skills and Experience: - Proficiency in PDF comparison tools - Attention to detail - Experience with purchase orders and acknowledgements

I have an Excel workbook in which numeric entries are a mess—some are real numbers, others are text strings littered with stray symbols, and quite a few mix commas and periods as decimal separators. I need every monetary figure, in every column that contains numeric data, converted so it behaves as a true number and displays in a single, consistent currency style: the $ symbol with two decimal places. Your task is to hunt through the file, detect any value that should be treated as money, automatically recognise whether the comma or the point is acting as the decimal marker, correct it, and then apply the chosen format. Dates, percentages, text, formulas, and the workbook’s structure must stay exactly as they are; after the cleanup nothing should break or recalculate incorrect...

I manage billing at a busy super-mart and the daily volume of customer details is now more than I can comfortably maintain on my own. I’m looking for a reliable data-entry clerk who can step in on a part-time basis and keep our customer information clean, complete, and up-to-date in Google Sheets. Here’s what you’ll do: • Log customer names, contact numbers, and purchase references from the point-of-sale slips into an existing Google Sheets template. • Double-check new rows for spelling, numeric accuracy, and consistent formatting. • Flag duplicates or incomplete entries so I can resolve them quickly. • Save and label each day’s sheet revision before your shift ends, ensuring I can trace changes if needed. Acceptance criteria: • 100 ...

I manage billing at a busy super-mart and the daily volume of customer details is now more than I can comfortably maintain on my own. I’m looking for a reliable data-entry clerk who can step in on a part-time basis and keep our customer information clean, complete, and up-to-date in Google Sheets. Here’s what you’ll do: • Log customer names, contact numbers, and purchase references from the point-of-sale slips into an existing Google Sheets template. • Double-check new rows for spelling, numeric accuracy, and consistent formatting. • Flag duplicates or incomplete entries so I can resolve them quickly. • Save and label each day’s sheet revision before your shift ends, ensuring I can trace changes if needed. Acceptance criteria: • 100 ...

I manage billing at a busy super-mart and the daily volume of customer details is now more than I can comfortably maintain on my own. I’m looking for a reliable data-entry clerk who can step in on a part-time basis and keep our customer information clean, complete, and up-to-date in Google Sheets. Here’s what you’ll do: • Log customer names, contact numbers, and purchase references from the point-of-sale slips into an existing Google Sheets template. • Double-check new rows for spelling, numeric accuracy, and consistent formatting. • Flag duplicates or incomplete entries so I can resolve them quickly. • Save and label each day’s sheet revision before your shift ends, ensuring I can trace changes if needed. Acceptance criteria: • 100 ...

I have a folder containing 909 image files that all need to appear inside a single Excel workbook. Each photo should sit in its own row, neatly sized so the sheet remains readable. In the next column I’d like the original file name copied exactly, so I can trace any image back to its source folder without confusion. All photos are ready to go; no editing or re-naming is required on your side—just bring them straight into Excel and line them up. When you finish, I will open the workbook on both Windows and macOS, so please embed the pictures (don’t link) and keep the file under the usual Excel size limits. Acceptance check: • 909 rows populated, one embedded image per row • Adjacent column shows the correct file name for every photo • Images are visibl...

I need an Excel sheet to record users for applications access review. The data should be organized in a pivot table for detailed analysis. This project involves an Applications Access Review, starting with two applications containing sensitive information. The goal is to clean up user access by gathering a list of users from each department in the company. These users will be reviewed, categorized, and unnecessary access will be eliminated. You need to record the following information: - User ID and names - Access levels and permissions - Last access date - Department - Inactive user And any other information that you recommend Ideal skills and experience: - Proficiency in Excel, especially with pivot tables - Experience in data organization and management - Attention to detail

I have 300 weekly Excel files, each following the same layout, and I need their key metrics rolled into one master workbook. I’m running the latest Excel from Office 2024, so Power Query is available and should be the ideal tool for this. What I want: a single, refreshable table that automatically pulls ten fields from every weekly file—dates, ROR, fund balances, calculated withdrawal amounts, and six other columns already labelled the same way across all workbooks. All 300 files sit in one folder; more will be added over time, so the solution has to cope with new files without extra setup. Please configure Power Query to: • Connect to that folder • Extract the ten columns in their native data types • Load everything into one structured table I can sort, ...

I have a locally stored Excel workbook that contains a financial-data Pivot Table. My goal is to move away from the static worksheet and make the figures available inside Power BI so I can build live dashboards and share them company-wide. Here’s what I need from you: • Take the existing Pivot Table and restructure the underlying data model so it works cleanly in Power BI—preferably in a star schema where possible. • Preserve every measure, calculated field, and filter currently used in the Excel view, translating them to DAX if required. • Deliver a Power BI file (.pbix) that automatically refreshes from the updated Excel source, along with concise documentation outlining the data-refresh steps. Acceptance will be based on side-by-side comparisons confirm...

I have an existing Excel workbook that needs to be populated with numerical data only. The structure of the sheet is already set up; what is missing are the actual figures. Accuracy is critical because the file feeds directly into my internal reports, so any typos or misplaced decimals will create downstream issues. You will receive: • The blank workbook with clearly labeled columns and any notes on acceptable value ranges. • Source documents containing the numbers to be entered. What I need back: • The same workbook returned, fully completed, double-checked for errors, and saved in .xlsx format. • A brief note highlighting any anomalies you spotted while entering the data (e.g., unreadable figures, missing values). Time is of the essence—I’d like the fin...

I have a ready-made Excel template and need all records typed accurately into the four columns—NAMA, NIK, NO KK, and ALAMAT. The structure is locked, so you will not add or reorder any fields. For NIK and NO KK, I follow national standards: each value must contain the exact number of digits (I will confirm the length guide with you before you begin), no spaces or separators, and every entry has to pass a simple checksum I run at the end. If a source record is incomplete or fails the length rule, you will flag it in a note column that already exists in the file. Because the sheet is already laid out, your task is purely data entry plus a quick self-check for those basic formatting rules. When you return the file I will run an automated validation; the job is considered finished once...

I have a 250 page ebook I want proof read and formatted. Chat gpt does it but it comes out missing 10 pages and I do not pay for the plus. I am looking to pay someone who is automated for this and not someone that wants to charge outrageously. Just formatted and proofed by AI. Please give me price. Thank you!

I need a set of source records copied carefully into a structured Excel workbook. Every value must be typed in by hand—no macros or scraping—so the data stays clean and uniformly formatted for later analysis. Once we start, I will share the raw files and a template that shows exactly where each field belongs. You will key in the data, verify spelling and numeric precision, and keep the sheet tidy so my formulas run without errors. The workload is sized so a focused freelancer can finish comfortably within a month, and I will be available throughout for clarification. To help me choose, include a brief example of past manual data-entry work you have completed. A screenshot or link to a spreadsheet that highlights your accuracy and consistency is enough. Deliverable: • Co...

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working directly in the spreadsheets I provide. Your job is to reorganize the information, apply consistent formatting, and generally make each sheet clear, readable, and ready for immediate use or reporting. Key deliverable • A single, well-organized Excel file for each original workbook, with clean headings, uniform cell styles, and properly structured tables (no stray blanks or merged-cell surprises). If you have a good eye for detail, solid Excel skills, and can turn this around efficiently, I’d like to hear how quickly you can start and your estimated completion time.

I need a set of source records copied carefully into a structured Excel workbook. Every value must be typed in by hand—no macros or scraping—so the data stays clean and uniformly formatted for later analysis. Once we start, I will share the raw files and a template that shows exactly where each field belongs. You will key in the data, verify spelling and numeric precision, and keep the sheet tidy so my formulas run without errors. The workload is sized so a focused freelancer can finish comfortably within a month, and I will be available throughout for clarification. To help me choose, include a brief example of past manual data-entry work you have completed. A screenshot or link to a spreadsheet that highlights your accuracy and consistency is enough. Deliverable: • Co...

I need an Excel sheet to manage and track inventory data. The sheet should allow users to manually input data and should be able to track stock levels, generate reports, and automate calculations. Key Requirements: - Track stock levels - Generate reports - Automate calculations Ideal Skills: - Proficiency in Excel - Experience with data entry sheets - Strong understanding of inventory management

I want a clean, reliable Excel workbook that lets me handle a full month’s payroll without extra software. The sheet has to: • Accept employee details I type in manually—names, pay rates, standard hours, overtime hours and any notes. • Calculate gross salary and overtime pay automatically as soon as I enter the figures. • Roll everything into a neat monthly summary so I can see totals for each employee and the overall payroll cost at a glance. A ready-to-use monthly payroll template is essential; I should be able to duplicate it for future months without breaking the formulas. Please keep the layout straightforward, protect any formula cells, and include a brief how-to tab so anyone on my team can update the file confidently. If you’ve built similar ...

I have several Excel workbooks that need a straightforward tidy-up. All the source material is already digital, so there’s no scanning involved—just working directly in the spreadsheets I provide. Your job is to reorganize the information, apply consistent formatting, and generally make each sheet clear, readable, and ready for immediate use or reporting. Key deliverable • A single, well-organized Excel file for each original workbook, with clean headings, uniform cell styles, and properly structured tables (no stray blanks or merged-cell surprises). If you have a good eye for detail, solid Excel skills, and can turn this around efficiently, I’d like to hear how quickly you can start and your estimated completion time.

Je dispose d’un fichier Excel déjà doté de macros (VBA) destiné à générer des comparateurs de fournisseurs détaillés. Plusieurs points bloquants sont apparus et je souhaite les résoudre tout en améliorant l’esthétique globale. Objectifs principaux • Corriger les erreurs d’automatisation qui empêchent l’affichage du logo lorsque je sélectionne un fournisseur. • Re-designer l’interface pour obtenir un rendu propre, cohérent et clairement professionnel (pas de style trop coloré, je vise quelque chose d’élégant et moderne). • Réparer la fonction d’export PDF : aujourd’hui l’extraction plan...

Estoy buscando un experto en Excel para el desarrollo (o adquisición) de una Plantilla de Funnel de Ventas Profesional. El objetivo es centralizar la gestión comercial en una herramienta robusta, intuitiva y visualmente atractiva que permita monitorear el ciclo de vida de los prospectos. Estructura Requerida (4 Módulos) Configuración Personalizable: Definición de etapas del embudo, tasas de conversión objetivo y validación de datos. Registro de Prospectos: Base de datos centralizada con campos para contacto, origen, etapa actual, valor de oportunidad y probabilidad. Visualización de Progreso: Pipeline activo con formatos condicionales para detectar cuellos de botella y estancamientos. Dashboard de Rendimiento: Panel visual con KPIs cl...

Tôi đang tìm một chuyên gia Excel có thể hướng dẫn tôi sử dụng phần mềm thành thạo cho công việc văn phòng hằng ngày. Những gì tôi mong đợi: • Giải thích rõ ràng các hàm và công thức cơ bản đến nâng cao (SUM, IF, VLOOKUP, PivotTable…). • Tư vấn cách định dạng bảng tính, quản lý dữ liệu và trình bày báo cáo chuyên nghiệp. • Cung cấp file ví dụ, bài tập thực hành và đáp án để tôi tự luyện sau mỗi buổi. • Hỗ trợ qua Zoom hoặc Google Meet, có thể chia sẻ màn hình, ghi lại phiên học để tôi xem...