Excel VBA Jobs

I need a clean, ready-to-use Excel file that lets me organise mobile numbers for my business contacts. I will be recording each contact’s name, company, designation, primary mobile number and a few optional fields such as email, city and short notes. The sheet must be simple for day-to-day data entry yet professional enough to filter, sort or search quickly when the list grows. Practical touches like data-validation on the mobile column (to ensure only 10-digit numbers), drop-downs for city or category, and conditional formatting for duplicates will help a lot. I’d also like a summary tab that instantly shows the total number of contacts and highlights any missing key details. Deliverable: one Excel workbook (.xlsx) that opens without macros on Microsoft 365, already formatte...

I want a single, well-structured Excel workbook that lets me create modular-kitchen quotations in minutes rather than hours. After I key in the material rates, labour rates, and any extra service fees, the sheet should automatically calculate subtotals for each category and then present a clear, tax-ready grand total. Core logic • Automated pricing calculations broken down into: – Material costs – Labour costs – Additional service fees Workflow expectations 1. I will enter or update all cost data manually in clearly marked input cells. 2. As soon as quantities are added, the workbook must pull the relevant rates, perform the maths, and display: line-item totals, category subtotals, overall total, and optional profit margin. 3. All formula cell...

Based on everything we’ve worked through, you’re not just building a dashboard—you’re building a workforce planning platform. A freelancer will do much better if they understand the business problem first. ⸻ Workforce Planning & Labor Intelligence Dashboard Project Overview I am creating an Excel-based workforce planning and labor intelligence tool for a large distribution center. The goal is to replace manual staffing decisions with a centralized, data-driven system that helps leaders make faster and more accurate labor decisions. The dashboard will combine information from multiple Excel sheets into one interactive workbook that automatically calculates staffing health, labor gaps, attendance, and workforce recommendations. This tool is designed for thre...

I need my date-tracking sheet polished today. Every date must follow a single style—spell out the month, then the year (for example, “January 2024”). While you work through the column, please realign any off-center cells and apply one uniform font family, size, and style so the whole sheet looks consistent. No duplicate removal or error checking is required; this is purely a formatting pass. Once the file comes back with tidy alignment, consistent fonts, and the new date format across the board, the job is done. I’ll send the spreadsheet as soon as you accept and will be available for quick feedback so we can wrap this up before the day ends.

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I use Tally Prime / Tally ERP for day-to-day bookkeeping and need experienced hands to keep everything up-to-date and fully reconciled. The workload centres on three core areas: • Voucher and ledger upkeep – enter every sale, purchase, payment, receipt and journal accurately each day so all ledgers stay current. • GST compliance – post GST invoices, then prepare the basic GST reports I need for filing (GSTR-1, GSTR-3B, mismatch checks). • Bank reconciliation – match bank statements with Tally, investigate variances and close each period with zero unreconciled items. Alongside Tally work, I often export data to Microsoft Excel for deeper analysis. You will create and maintain spreadsheets that include clean data entry sheets, smart formulas and automat...

My current bookkeeping is scattered and I want everything organised in one Excel file that lets me record every income and expense once and then shows me clear, ready-to-print financial reports automatically. Scope of work • Build a clean data-entry sheet dedicated to Income and Expenses, with columns such as date, category, description and amount. • Create the behind-the-scenes formulas that roll those entries into running totals, monthly and yearly summaries, and an overall balance. • Add a separate “Reports” tab that pulls the data into at least a profit-and-loss style summary plus any other insightful views you think would help me monitor cash flow quickly. Dynamic tables, slicers or simple charts are welcome if they keep the file easy to use. •...

I need an Excel document converted to a Word form. The Word form should include fillable text boxes. Requirements: - Transfer data from Excel to Word - Create fillable text boxes in Word - Text boxes must be fixed size Ideal Skills & Experience: - Proficiency in Microsoft Excel and Word - Experience creating fillable forms in Word - Attention to detail and formatting skills

I want to turn a workbook that currently relies on manual typing into a push-button process. The flow is simple in theory—data comes from people keying numbers or text straight into Excel—yet it’s time-consuming and error-prone. Here’s what I need: when a user opens the file, they should be guided through an organised form or other intuitive interface that writes their input to the correct sheets, performs validation, and stamps a time-and-user log automatically. As soon as the new records land, Excel should run the built-in statistical routines I specify (mean, standard deviation, t-tests, simple regressions and similar core stats) and update all summary tables, charts and printable reports without further clicks. I’m comfortable if you lean on VBA, mac...

I need an Excel price sheet recreated for printing. Requirements: - Include product names and prices - Simple table format - Company logo and contact information - Create separate retail and wholesale versions Ideal Skills: - Proficiency in Excel - Experience with creating printable price sheets - Attention to detail and good design sense for simple, professional layouts

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I’m looking for a patient instructor who can walk me through two key areas that I use every day but still don’t feel fully confident about: Excel and general email management. On the Excel side, my goal is to become comfortable with basic formulas and functions (SUM, AVERAGE, IF, etc.) and then quickly move into creating clear, compelling charts or graphs for small reports. I don’t need advanced automation or pivot tables right now—just practical, hands-on skills I can apply immediately in my job. For email, I’d like to streamline the way I organize my inbox and folders, create rules or filters, and generally adopt best practices so important messages never slip through the cracks. Here’s how I picture the collaboration: • Short, focused sessions...

I need an Excel expert to improve my existing business workbook. The sheet already contains customer details, revenue, expenses, profit, and aggregator information. I want to add a professional dashboard with monthly and yearly comparisons, partner-wise analysis, charts, graphs, KPIs, and other visual reports to help me track business performance. The final workbook should be automated, user-friendly, and easy to update with new data.

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I need help correcting formula errors in a complex Excel spreadsheet. Requirements: - Fix formula errors in specific sections - Ensure data integrity and accuracy Ideal Skills: - Advanced Excel proficiency - Strong problem-solving skills - Attention to detail Experience with complex spreadsheets is a plus.

I have several Excel spreadsheets holding strings of information—names, addresses, reference notes, short descriptions—that all need to be brought into one clean, consistent master sheet. Every entry must be copied exactly as written, checked for stray spaces or line-break issues, and parked in the correct column of the template I will share at kickoff. The job is entirely text-based; no numeric formulas or image conversions are involved. Source files are already in .xlsx format, so you can work directly inside Excel without any import steps. Simply follow the field order I supply, keep capitalization exactly as shown, and flag any illegible or duplicate items in a separate tab so we can review them later. Deliverable: • A final Excel workbook containing all supplied rec...

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I am looking for an Excel specialist to develop a professional executive dashboard based on an existing and structured Excel database. The dashboard must closely follow the attached reference image, maintaining the same visual style, layout, KPI cards, charts, and indicators. The workbook already contains the database, formulas, and part of the structure. The scope of work is to build the dashboard, configure Pivot Tables, Slicers, Timeline, and dynamic charts, delivering a modern, clean, and fully functional dashboard for executive presentations. Proven experience with professional Excel dashboards is highly desirable. If you have prior examples of Excel dashboards—especially around HR or performance management—feel free to include a screenshot or brief description when you re...

I'm looking for an Excel expert to help with financial calculations, specifically for creating and fixing formulas on an expense report for a small company. Key requirements: - Proficiency in Excel, especially in financial formulas - Experience in creating and fixing complex formulas - Ability to organize and analyze financial data Ideal skills and experience: - Background in finance or accounting - Strong problem-solving skills - Attention to detail and accuracy Your expertise will help streamline our expense reporting process.

I’m consolidating a mixed set of text and numerical records into an Excel-based database. Your task is to take the source documents I provide and enter every field into my pre-formatted spreadsheet template, keeping both the layout and data types intact. The files include names, descriptions, IDs, quantities, and prices, so close attention to text accuracy and proper numeric formatting is essential. I’ll share a short walkthrough video, the template (.xlsx), and a list of validation rules with dropdowns and conditional formatting already in place. Deliverable • A fully populated Excel file that mirrors the template, free of typos, empty rows, or formatting drift. Acceptance criteria • 100 % of source rows transferred. • No numeric field stored as text. ...

I need assistance in converting Excel vb script that generate contract in docs using macro into Python scripts. The project involves: - Converting mathematical and text manipulation formulas - Working with Vb scripts that pull data from Excel - Generating Word contracts using the data Ideal skills and experience: - Proficiency in Python - Strong understanding of Excel formulas - Experience with data manipulation and automation tasks - Familiarity with generating Word documents through Python Please provide examples of similar work done.

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I have an Excel workbook called “VlookupPracticeExamples.xlsx.” The VLOOKUP formulas that are already in place appear to be returning the wrong values, even though they do not produce a #N/A message. I need someone to open the file, diagnose exactly why the lookups are pulling incorrect results, and then correct every affected formula so the returned values match the underlying data. Please keep your approach transparent: highlight any range issues, column-index mistakes, or lookup-type mismatches you uncover, and then replace or adjust the formulas accordingly. A short note inside the sheet (or a separate tab) explaining each fix will help me follow your logic later. To apply, send over a brief example of past work where you successfully traced and resolved VLOOKUP or simila...

I need a professional to assist with multiple financial and Excel tasks. Key Responsibilities: - Automated Reporting in Excel - Data Validation and Verification - Managing EPF, ESIC, and P Tax Returns - Handling TALLY, GST, and TDS Returns Ideal Skills: - Expertise in Excel, especially in automated reporting - Experience with EPF, ESIC, P Tax, TALLY, GST, and TDS - Strong attention to detail for data validation Please provide relevant experience in your bids.

I have a collection of printed documents that I need converted into clean, well-organized text inside an Excel spreadsheet. Each page contains straightforward text—no complex tables or mixed numerics—so the task is to read the printed material and key the wording exactly as shown into the designated columns I will provide. Accuracy is critical. I will supply high-resolution scans (PDF) along with a short guide that explains the column layout, required sheet names, and a few simple validation checks I use. Once you finish a batch, I’ll spot-check for typos and consistency in capitalization, spacing, and line breaks before approving the next batch. Deliverable: the completed Excel file with every page of text entered, saved in .xlsx format and ready for immediate use. If ...

Developed an interactive Logistics & Delivery Performance Dashboard in Excel using Power Query, Pivot Tables, Pivot Charts, KPI Cards, and Slicers. Analyzed 5,000+ e-commerce orders by performing data cleaning, handling missing values, creating custom metrics (Delivery in Days, Delivery Performance, and Total Logistics Cost), and generating business insights related to delivery efficiency, cancellations, logistics costs, and product demand.

I have a sizeable spreadsheet that needs a thorough clean-up in Microsoft Excel. The raw file contains duplicates, inconsistent formats, stray blanks and a few obvious typos. I’m looking for someone who can methodically work through the sheet—using whatever mix of formulas, Power Query, or manual checks you prefer—to deliver a polished, analysis-ready workbook. Accuracy is more important than speed, so the timeline is flexible. When you respond, please highlight your experience handling similar Excel data-cleaning jobs; examples of past successes will help me gauge fit. Final deliverable: the cleaned Excel file plus a short note summarising the main issues you found and the fixes you applied.

Developed an interactive Logistics & Delivery Performance Dashboard in Excel using Power Query, Pivot Tables, Pivot Charts, KPI Cards, and Slicers. Analyzed 5,000+ e-commerce orders by performing data cleaning, handling missing values, creating custom metrics (Delivery in Days, Delivery Performance, and Total Logistics Cost), and generating business insights related to delivery efficiency, cancellations, logistics costs, and product demand.

I have several Excel workbooks that contain raw income-statement figures. Before I can run any meaningful analysis, the data needs a careful pass of cleansing—removing duplicates, fixing inconsistent formats, standardising account names—and then re-entered into a tidy, well-structured sheet that aligns with my chart-of-accounts layout. Here is what I expect: • Every line item in each workbook reviewed and corrected for spelling, date and numeric formatting. • Uniform column order (period, account code, account name, amount, notes). • One consolidated, error-free master sheet delivered back in .xlsx format. I will provide the existing Excel files and a brief style guide for headers and acceptable account names. No OCR or PDF conversion is required; everythin...

I am developing a three-month CCC-style curriculum dedicated entirely to Excel for an audience of advanced users. Although they already work confidently inside the program, the goal is to move them from everyday competence to power-user level. The syllabus must weave together a quick refresher on basic functions and formulas, a solid block on data analysis with pivot tables, and a deep dive into macro recording and full-blown VBA scripting. Each concept should be taught through practical, business-oriented scenarios and reinforced with progressively challenging projects that the students can solve in class and finish at home. I am happy to blend delivery formats—video walkthroughs, PDF manuals, or interactive modules—so feel free to propose whichever mix supports hands-on lea...

I need an existing insurance company commissions spreadsheet manipulated to sort and combine data for import into EZLynx. Requirements: - Sort all data (policy details, customer info, claims records) by policy number. - Combine data to include commission amounts. - Import it into a certain template that is the uploading format for EZLynx. - Provide instructions (or macro?) that is repeatable on a monthly basis. Ideal Skills: - Experience with data manipulation and spreadsheet software. - Familiarity with EZLynx and insurance data.

I maintain a master Excel workbook that tracks our sales performance, and I need it kept perfectly up-to-date. The data you will work on is strictly sales-related; every week fresh numbers come in and some product attributes change, so accuracy and consistency are critical. Your core focus is twofold: • Product details – correcting SKUs, names, categories or price changes the moment I provide them. • Sales figures – inserting the latest weekly totals, making sure formulas, subtotals and running summaries continue to calculate correctly. I’ll supply the raw export each week. You’ll clean it, paste or import it into the existing sheet, verify that look-ups, conditional formatting, pivot tables and charts still function, then return the finished file re...

I have an Excel file containing just over 4,350 retail transactions from 2023-2024 (about $1.8 million in total sales). What I need is a clear, Excel-based view of how revenue moves month-by-month—nothing else; region and product splits are not required for this engagement. Here is exactly what I’m after: • A cleaned worksheet where date fields are consistent and any blanks or obvious entry errors are resolved. • A dynamic PivotTable that rolls revenue up by month, ready for quick filtering or drill-down. • A formula-driven summary table (using SUMIFS / COUNTIFS) that shows total monthly revenue, order count, and average order value side by side. • At least one well-formatted chart linked to the PivotTable that makes the monthly trend visually obviou...

I have a raw worksheet that needs tidying before it can drive the Pivot-tables I want. Your first task will be to shape and clean the data set—remove duplicates, standardise headers, and make sure each column is analysis-ready. Once the source is organised, I need a set of clearly formatted Pivot tables that let me slice the information by category, date and region. Consistent number formats, readable layouts, custom styles and any useful slicers are essential; I’d also like the file to stay refresh-friendly so I can drop in new data later without breaking the structure. Deliverables • Cleaned, well-structured source sheet • At least three Pivot tables with professional formatting and slicers • Short note explaining how to refresh or expand the data in ...

I need a professional to assist with multiple financial and Excel tasks. Key Responsibilities: - Automated Reporting in Excel - Data Validation and Verification - Managing EPF, ESIC, and P Tax Returns - Handling TALLY, GST, and TDS Returns Ideal Skills: - Expertise in Excel, especially in automated reporting - Experience with EPF, ESIC, P Tax, TALLY, GST, and TDS - Strong attention to detail for data validation Please provide relevant experience in your bids.

Saya membutuhkan bantuan untuk menangani pekerjaan data entry berbasis Excel. Fokus utamanya: • Memasukkan data dari berbagai sumber (file CSV, PDF, atau website internal) ke dalam template Excel yang sudah saya sediakan. • Membersihkan, menata ulang, dan mengelompokkan data agar formatnya konsisten, bebas duplikat, serta mudah difilter dan dianalisis. Saya akan menyerahkan file sumber, panduan penamaan kolom, dan contoh akhir yang diharapkan. Silakan gunakan fitur‐fitur Excel seperti sort, filter, text-to-columns, dan formula sederhana (VLOOKUP, IF, atau sejenisnya) bila diperlukan. Hasil akhir yang saya inginkan berupa satu berkas Excel siap pakai dengan sheet terstruktur rapi beserta catatan singkat tentang langkah pembersihan yang Anda lakukan. Prioritaskan akurasi dan k...

Tengo casi lista una hoja de cálculo en Excel para el control de tareas y necesito tu mano experta para cerrarla con broche de oro. Lo que falta es muy concreto: • Convertir la columna “Estado” en una lista desplegable que muestre solo las opciones de Estado de tarea que ya tengo definidas. • Configurar una barra de progreso basada en Porcentaje que se actualice automáticamente al marcar las tareas como completadas o en curso. • Dejar la plantilla limpia y fácil de extender, documentando en comentarios breves las fórmulas o reglas condicionales que utilices. Trabajo con la versión de Microsoft Excel de escritorio, así que cualquier solución debe ser 100 % compatible (sin macros prohibidas en línea). S...