
Closed
Posted
Paid on delivery
I need a simple, reliable VBA macro that scans an Excel workbook and replaces specific words only—no pattern matching or regex, just straight one-to-one swaps. The list of target words and their replacements will already be laid out for you across multiple columns in a dedicated sheet; the macro should read directly from that sheet, loop through the rest of the workbook, and make the substitutions wherever they occur. Key points you should build in: • Action: word-for-word replacement (this is a data-processing task, not data entry or extraction). • Source list: multiple columns on a single sheet; assume column A holds the words to find and column B the words to insert. • Scope: apply changes to every cell in every sheet unless I later flag specific sheets to exclude. • Usability: one clearly labelled button or a shortcut to run the macro, with a brief message box summarising how many replacements were made. • Clean code: comment your logic so I can tweak column references or sheet names if needed. Deliverable is the .xlsm file (or a .bas module) containing the fully tested macro, ready for me to drop into my workbook.
Project ID: 40208179
22 proposals
Remote project
Active 11 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $38 USD for this job

As an experienced Full-stack Developer and specialist in Excel VBA, I understand the importance of data accuracy and efficient solutions. My skill set aligns perfectly with your project requirements. I have a significant amount of experience developing Excel macros to scrape and process data, ensuring they are clean, precise, and reliable for further analysis which will be fundamental for this project. One of my key USPs is my fast turnarounds on projects, often exceeding client's expectations without compromising the quality of the work. The anticipated macro development would be no different; clean code with well-commented logic for easy customization, as required. This 'Plug & Play' solution would let you easily swap between sheets or column references, making it suitable for your long term use. But let me just stress one of my key strengths that I often get complimented on, it's my availability and response time. My clients can vouch how important is dealing in uncertain situations and tight deadlines. To add a bonus to you, if you need any tweaking in this macro or even if it is means debugging existing code or technical consultation in the future, I am here to assist you as I consider developing long term relationships with employers to understand their unique needs better
$100 USD in 3 days
8.6
8.6

Hi, i can do this right now, Thanks...
$30 USD in 1 day
7.4
7.4

Hello I have several years of experience with Excel Macros and Visual Basic for application About your project - it's something straightforward I can complete to in couple of hours of working time
$16.90 USD in 1 day
7.2
7.2

I, Md Masudur from Zayer Tech, am a seasoned professional at Data Entry, Data Processing and Excel. I can provide you with a reliable and efficient VBA macro designed to precisely swap specific words in your Excel workbook. My approach is straightforward - I will extract the words to find and insert from dedicated columns in a single sheet, loop through your entire workbook, and make the exact replacements wherever they occur. To ensure usability, I'll create a clearly labeled button or shortcut for executing the macro, accompanied by an informative message box that summarizes how many replacements were made. Moreover, to make the process more user-friendly, I'll also comment on the logic of the code so future adjustments like column references or sheet names can be easily made by you if needed. Working with Zayer Tech means availing not only exceptional technical skills but also comprehensive project management aid backed by my PMP-certification. This combination allows me to understand the bigger perspective of your project and execute accordingly. With proficiency spanning from AI Integration & Process Automation to Quality Assurance & Testing, I intend to put my diverse expertise to work to deliver exceptional results that drive efficiency and innovation for your specific needs.
$20 USD in 7 days
6.8
6.8

I have over 10+ years of experience Excel Maro. Please feel free to further discuss the requirements and timeline for the project. I'd be happy to assist you. I am ready to start right now. You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you
$30 USD in 1 day
6.3
6.3

As an expert in Excel automation and a proficient VBA coder, I would be the best fit for your project. My experience in developing intricate Excel macros and my advanced comprehension of VBA are tailored to this very task. Through parsing given data, engaging the appropriate columns in the source list, and applying the specified substitutions across multiple sheets; you can be certain of a clean, smooth-running tool when I'm done. Not only do I focus on just data processing, but I'm able to turn "messy" data into organized, efficient and visually appealing spreadsheets that can save you time and minimize errors. Just as you requested, utilizing specific column references instead of hard-coding them is no challenge to me - ensuring you have full control over your tool even after my engagement. In addition to being well-versed with your project requirements, my round-the-clock availability guarantees you timely service. I'll deliver a fully tested macro embedded within a .xlsm file (or a .bas module) fulfilling all your needs. Let's make it easy for you to extract useful information from your data - contact me now!
$20 USD in 1 day
4.9
4.9

Hi there! I will develop a clean, fully-commented VBA macro that scans your workbook and performs precise word-for-word replacements based on your reference sheet. The solution will include an easy-to-run button, a summary message box, and flexibility for future tweaks. With 8+ years of experience in Excel, I deliver accurate, efficient, and well-structured data solutions—on time and within budget. I specialize in: Advanced Excel dashboards, formulas, and pivot tables Data cleaning, analysis, and visualization VBA/Macro automation to save time Google Sheets automation via Apps Script You’ll receive: Fully editable, documented files Clean, easy-to-use dashboards Fast communication and unlimited revisions View my profile and work: freelancer.com/u/muhammadj121 Looking forward to helping streamline your data processes! – Junaid
$350 USD in 2 days
3.6
3.6

Hello, I understand you need a straightforward VBA macro that performs exact word-for-word swaps across an entire workbook using a predefined list, with no regex or pattern tricks involved. I’ve built clean Excel automation like this by reading replacement pairs directly from a control sheet, looping safely through all cells, and applying precise substitutions while tracking totals. I’ll include clear comments so you can easily adjust sheet names or columns later, add a single button or shortcut to run it, and show a concise summary of how many replacements were made once finished. The result will be a reliable, easy-to-extend macro you can drop straight into your file. Nassim
$15 USD in 1 day
2.9
2.9

I have around 16 years of coding experience developing Excel utilities using VBA/Macros I think I can do it
$10 USD in 1 day
1.7
1.7

I’ve reviewed your project and believe I’m the perfect person to bring it to life! You’re looking for a simple, reliable VBA macro that performs clean word-for-word replacement across every sheet, reading directly from a dedicated source list, with a clear button, summary message, and well-commented logic for easy tweaking. I specialize in Excel VBA automation, workbook-wide data processing, and building clean, professional, user friendly, seamless, integrated and automated solutions. While i am new to freelancer.com, i have tons of experience & have done tons of other projects off site. Regards, Keenan
$20 USD in 7 days
1.0
1.0

Hi there, You’re absolutely in the RIGHT PLACE. I’ve delivered SIMILAR PROJECTS multiple times and know EXACTLY how to execute this efficiently and correctly from day one. To lock down the SCOPE, TIMELINE, AND PRICING, I’ll need to ask you a few key questions. Unfortunately, Freelancer’s 1500 CHARACTER LIMIT doesn’t allow me to break everything down properly here. Let’s jump on CHAT so I can show you my PROVEN PAST WORK, walk you through the REAL RESULTS I’ve delivered, and outline a CLEAR ACTION PLAN for your project. You’ll immediately see why my approach is DIFFERENT and EFFECTIVE. If you’re serious about getting this done RIGHT, I’m ready to move forward. Looking forward to CONNECTING and WINNING TOGETHER. Cheers, Mayank B
$20 USD in 7 days
0.0
0.0

IM OFFERING 6 MONTHS FREE MAINTANENCE!!!! New freelancer. Experienced developer. Fully committed to your success. I’m building my reputation, which means I care more about quality and satisfaction than the paycheck, giving you dedicated effort, clear communication, and excellent results at a competitive rate. I am currently doing a similar project where I developed a VBA macro that efficiently replaced specific words in an Excel workbook. This gave me ample experience with the exact kind of work you need and makes me confident in my ability to handle your task effectively and accurately.
$20 USD in 7 days
0.0
0.0

Hello, I can deliver exactly what you’re looking for: a simple, reliable Excel VBA macro that performs straight word-for-word replacements across your entire workbook—no regex, no pattern logic, just clean one-to-one swaps. How I’ll implement it: Read the replacement list directly from a dedicated sheet Column A → words to find Column B → replacement words Loop through every cell in every worksheet (with the option to easily exclude sheets later). Perform exact text replacements only (safe for data processing). Add a clearly labeled button (and optional shortcut) to run the macro. Show a summary message box after execution (total replacements made). Write well-commented, clean VBA code so you can easily modify: Sheet name Column references Scope rules Deliverable: Fully tested .xlsm file or .bas module Ready to drop into your workbook and run immediately I’ve worked extensively with Excel VBA automation and data-processing macros, and I focus on reliability and clarity—not over-engineering. If you’d like, I can also: Add sheet-exclusion logic Add a dry-run / preview mode Optimize performance for very large workbooks Looking forward to working with you. Best regards, Muhammad Sohail
$10 USD in 2 days
0.0
0.0

As an entrepreneur with a solid understanding of technology, I've spent years building my own brand, working in e-commerce, brand management, and digital design – all areas that require exactitude and close attention to data. My expertise also extends to finance, ERP, data analysis, and technical operations. These skills are directly applicable to your project, as they require a precise understanding of data management and processing. In addition to my substantial experience in these areas, I hold a particular proficiency in Microsoft Excel. My mastery includes utilizing powerful features such as VBA macros for automating data processing tasks like the one you require. I work methodically ensuring that my VBA code is clean and comprehensible with thoughtful comments. This makes future tweaking easier for the user, even if they are unfamiliar with VBA. Lastly, I want to emphasize my dedication to growth and adaptation. In this rapidly changing technological landscape, it is essential to stay up-to-date. That's why not only do I have a firm foundation in Excel but also continuously strive to learn more every day. Combining an innovative mindset with a wealth of technical knowledge, I believe I am well-suited for this project. Should you choose me as your freelancer, you can expect a robust yet user-friendly macro that executes precise word-for-word replacements throughout your workbook.
$20 USD in 7 days
0.0
0.0

Hello, I am a professional Data Entry specialist with strong experience in Excel, Word, and Google Sheets. I have completed many similar projects before with 100% accuracy. I can finish your task manually and within a short time. If you are looking for quality and quick delivery, I am the right person for this job. I am ready to start immediately. Thank you.
$26 USD in 7 days
0.0
0.0

Hola! Puedo desarrollar tu macro de VBA para reemplazo masivo de palabras de manera eficiente y limpia. Como programador enfocado en procesamiento de datos, mi solución incluirá: Lógica de mapeo directa: El script leerá tu hoja de origen (Columnas A y B) y aplicará los cambios en todo el libro. Optimización: Usaré el método Replace nativo de Excel para que la macro sea rápida incluso en libros grandes. Interfaz simple: Un botón de ejecución y un cuadro de mensaje final con el resumen de cambios realizados. Código comentado: Dejaré instrucciones claras dentro del código para que puedas ajustar columnas o excluir hojas fácilmente en el futuro. Puedo entregarte el archivo .xlsm listo para usar hoy mismo.
$10 USD in 7 days
0.0
0.0

Hi interested in doing this project, can deliver it within 1 day. As per my understanding this is a word replacement script you want to run on several excel sheets. Please contact for further details.
$10 USD in 7 days
0.0
0.0

Hello, I can create a simple and reliable VBA macro for your Excel workbook that performs straight word-for-word replacements. The macro will: ✔ Read the find-and-replace list directly from your dedicated sheet (Column A = words to find, Column B = replacements) ✔ Loop through every cell in every sheet (with option to exclude specific sheets) ✔ Make direct substitutions without using patterns or regex ✔ Include a clearly labelled button or shortcut to run the macro ✔ Show a message box summarising the total number of replacements ✔ Include clear comments so you can adjust sheet names or column references easily I will deliver a fully tested .xlsm file or .bas module, ready to drop into your workbook and use immediately. I am confident I can complete this accurately and efficiently. Thank you for considering my bid.
$10 USD in 7 days
0.0
0.0

As an experienced developer, I’m adept at handling data management tasks efficiently and effectively. My experience with Visual Basic for Applications (VBA) makes me the ideal candidate for this project. I can create the VBA macro that you require to scan your Excel workbook, identify specific words using column references and replace them with precision. In addition to my technical proficiency, I bring a unique perspective on digital products. As you mentioned, this project isn't only about data processing; it's about laying a strong foundation for future growth. This is where my passion for creating impactful experiences comes in. I approach every project by considering not just the immediate requirement but also long-term scalability and usability. With this macro tool in place, you will have a powerful, reliable solution that won't just solve your current needs but also adapt effortlessly as your workbook grows. My commitment to clean code and thorough documentation makes it easy for users to make tweaks as per their needs. So, in case columns or sheet names change down the line, you can comfortably update them without breaking the entire code structure. With me, you get the expertise of a seasoned developer who values not just functionality but clarity and consistency as well. Choose me for this project, and I promise to deliver exactly what you need - a tested .xlsm file containing a sturdy macro ready to launch into your workflow!
$40 USD in 7 days
0.0
0.0

I understand you need a straightforward VBA macro that performs exact word-for-word swaps across an entire workbook using a predefined list, with no regex or pattern tricks involved. I’ve built clean Excel automation like this by reading replacement pairs directly from a control sheet, looping safely through all cells, and applying precise substitutions while tracking totals. I’ll include clear comments so you can easily adjust sheet names or columns later, add a single button or shortcut to run it, and show a concise summary of how many replacements were made once finished. The result will be a reliable, easy-to-extend macro you can drop straight into your file.
$20 USD in 5 days
0.0
0.0

Eilon, Israel
Payment method verified
Member since Jan 25, 2022
$30-250 USD
$30-250 USD
$250-750 USD
$30-250 USD
$30-250 USD
₹750-1250 INR / hour
₹1500-12500 INR
$150-500 CAD
₹600-1500 INR
₹600-700 INR
$30-250 USD
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
€12-18 EUR / hour
$3000-5000 USD
₹400-750 INR / hour
$15-25 USD / hour
$250-750 USD
₹100-400 INR / hour
₹12500-37500 INR
$30-250 USD
$10-30 USD
€30-250 EUR
₹750-1250 INR / hour