
Closed
Posted
Paid on delivery
I have a contacts worksheet in Google Sheet for Mac that often contains more than one row with the same email address. What I need is a lightweight macro I can trigger from a button or shortcut that will: • scan the sheet, • find every email that appears more than once, and • highlight each duplicated entry in red—nothing is to be deleted automatically. The highlight-only approach lets me decide, on a case-by-case basis, which full contact row to keep and which to remove. Aside from the red fill on duplicates, the script must leave every other part of the workbook untouched. Please deliver a ready-to-use VBA module (or an entire macro-enabled workbook if you prefer) that works smoothly in current Mac Google Sheets, along with a short set of installation and usage notes so I can drop it into future files just as easily.
Project ID: 40210299
75 proposals
Remote project
Active 10 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
75 freelancers are bidding on average $109 CAD for this job

Hello Sir, I can deliver a lightweight macro that scans your Google Sheet, identifies repeated email addresses, and highlights every duplicated row in red without deleting anything. You’ll receive a ready-to-use script with simple button/shortcut triggering and clear installation and reuse notes suitable for current Mac Google Sheets.
$100 CAD in 1 day
8.6
8.6

Having been a full stack developer for 7 years, specializing in Excel Macros and VBA, I am confident that I can provide you with the high-quality, efficient solution you need. Working with top companies like Metlife GOSC and DXC technologies has honed my ability to deliver reliable and effective scripts - something that will undoubtedly serve your project well. Your request for a lightweight macro that scans your Google Sheet for duplicate email addresses and highlights them in red aligns perfectly with my skill set. Over time, I have mastered the art of accomplishing complex tasks while maintaining simplicity in their execution. My method is especially useful when working alongside sheets that contain valuable information needing to be preserved, just like yours. With my guarantee of 100% employer satisfaction, I'm prepared to work closely with you to ensure your sheet is performing optimally. Let's build a long-term relationship where I help automate several aspects of your business saving on cost and time. Hire me!',
$220 CAD in 4 days
8.4
8.4

Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$140 CAD in 7 days
7.1
7.1

Good day! Here's how we can help: * Create a lightweight macro for your Google Sheet that scans your contacts worksheet for duplicate email addresses * Highlight all duplicates in red without deleting or altering any other data * Make it triggerable via a button or shortcut for easy use * Provide clear installation and usage instructions so you can reuse the macro in future sheets We are a team of 62 professionals with over 9 years of experience building Google Sheets automations, macros, and scripts that are clean, reliable, and easy to maintain. Could you confirm whether you’d like this implemented as a Google Apps Script (recommended for Google Sheets on Mac) rather than VBA, so it works seamlessly in the cloud?
$250 CAD in 7 days
6.7
6.7

As a team, we bring more than a decade of experience in data processing and automation to the table, making us a perfect fit for your project. We have successfully completed over 345 projects, and our skills include expert knowledge of Google Sheets, Excel, VBA, and Python - the exact tools you need for your project. The challenge you're facing with duplicated email addresses in your contact worksheet is a common one but needs an efficient approach. Our years of experience have honed our abilities even to tackle complex tasks like yours with ease. I assure you that we can develop the lightweight macro/module that you need, which will not only scan and identify duplicates but also highlight them in red without interfering with any other sections of your workbook. Imagine having an automated solution that would take care of duplicate entries for you on the go within literally one touch! In addition to providing the ready-to-use VBA module or macro-enabled workbook, we also offer comprehensive installation and usage notes so you can use it across your files seamlessly. With us as your dedicated team, not only do you get top-notch service but also long-term support until you are fully satisfied. So, why wait? Let's Get Started!
$50 CAD in 1 day
6.8
6.8

Hello, I've carefully reviewed your project requirements for a lightweight macro in Google Sheets on Mac to scan for duplicate email addresses, highlight them in red without deletions, and provide easy installation for future use, and I'm confident in delivering a simple, reliable solution that fits seamlessly into your workflow. I will start by writing a custom Google Apps Script in JavaScript, using the SpreadsheetApp service to access your sheet and scan the email column for duplicates via an efficient array-based comparison. Next, I will implement conditional logic to apply red background fills only to duplicated rows, ensuring no other data or formatting is altered. Then, I will add a trigger function callable from a custom menu or button, with error handling for edge cases like empty sheets. Finally, I will deliver the ready-to-copy script code, a sample workbook if needed, and concise installation notes for adding it to any Google Sheet via the Extensions menu. What is the specific email column (e.g., Column B) or sheet name to target in the initial script setup? Let's chat now to confirm details and get your macro deployed quickly. Best Regards, Aneesa.
$125 CAD in 1 day
6.7
6.7

With over 5 years of experience in web development and proficiency in Node.js, React, PHP, and Excel automation, I am confident I can deliver the perfect solution for your Google Sheets project. I will create a lightweight macro that scans your sheet, highlights duplicate email addresses in red, and leaves the rest of the workbook untouched. You can trust me to provide a ready-to-use VBA module along with detailed installation and usage notes for seamless integration into future files. Let's work together to streamline your contact management process.
$100 CAD in 7 days
5.7
5.7

Hi, I’ll deliver a lightweight, one-click duplicate-highlighting script tailored for Google Sheets on Mac—safely flagging repeated email addresses in red without altering any data. You’ll get a clean, reusable solution (Apps Script + button/shortcut) with clear setup notes so you can drop it into future sheets effortlessly. You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you
$75 CAD in 1 day
6.1
6.1

Hi there, I read your project and I'm excited about the opportunity to help you streamline your contacts worksheet in Google Sheets! I understand that you need a lightweight macro to effectively identify and highlight duplicate email addresses, allowing you to manage them with ease. With extensive experience in creating Google Sheets scripts and Visual Basic for Apps, I can develop a solution that will scan your sheet, highlight duplicates in red, and maintain the integrity of your data without any automatic deletions. I will also ensure that the module comes with clear installation and usage notes so you can easily implement it in your future files. I can deliver this ready-to-use macro within 3 days, allowing you to start organizing your contacts efficiently.
$200 CAD in 2 days
5.1
5.1

As your project title suggests, to effectively filter and process data, it is crucial to identify any duplicates promptly. My expertise in data management, particularly using Excel macros and VBA, guarantees a seamless solution for you. I can quickly develop a lightweight macro that will effortlessly scan your Google Sheets for duplicate emails and highlight them in red - leaving your files intact. Apart from being a master of data processing, I'm also proficient in graphic design - a skill that will complement the final deliverable by providing an organized, visually appealing and user-friendly Google Sheets model. Additionally, my knowledge in virtual assistance leaves no room for unsatisfactory communication. I am able to provide in-depth installation instructions and ongoing support to ensure that you are confident on how to use the macro to continue enhancing your data management. Furthermore, as an experienced freelancer with strengths in everything from Graphic Design to Web Scraping and Programming, I bring a fresh perspective to each task by considering multiple angles and making sure I deliver results that meet not just the requested functionality but also an excellent user experience. Whether you need assistance assembling significant meeting notes or ongoing clarifications on any data issues as they arise, I assure you that working with me on this project promises promptness alongside reliability.
$100 CAD in 1 day
5.1
5.1

Hi, there, I am experienced in Excel Macros, Data Analysis, and Google Apps Scripts, with a strong proficiency in Visual Basic for Apps and Excel VBA. I specialize in data processing and management, ensuring efficient solutions tailored to your needs.✅ Utilizing my expertise, I will develop a lightweight VBA module for Google Sheets on Mac, enabling you to highlight email duplicates seamlessly.✅ The script will scan the sheet, identify duplicate emails, and highlight them in red, maintaining the rest of the workbook untouched.✅ I will deliver a user-friendly VBA module with clear installation and usage instructions, empowering you to manage duplicates effortlessly.✅ My solution will prioritize user control, allowing you to decide on contact rows to keep or remove, ensuring a tailored and efficient workflow.✅ With a focus on data accuracy and ease of use, I guarantee a smooth and effective solution for your contact management needs.
$200 CAD in 3 days
5.2
5.2

⭐Hello [ClientFirstName], I’m ready to assist you right away!⭐ I believe I’d be a great fit for your project since I excel in data processing, data analysis, and scripting. With my experience in Excel VBA, Google Apps Scripts, and Visual Basic, I am well-equipped to create a lightweight macro for your Google Sheets contacts worksheet that highlights duplicate emails without altering any other data. This approach allows you to make informed decisions on which contact rows to keep. The macro will be user-friendly, triggered by a button or shortcut, and come with clear installation and usage instructions. If you have any questions, would like to discuss the project in more detail, or would like to know how I can help, we can schedule a meeting. Thank you. Maxim
$30 CAD in 3 days
4.5
4.5

Hi, I am a developer with 8 years of experience building lightweight automation scripts and data-processing tools focused on accuracy and non-destructive workflows. I’ve worked extensively with spreadsheet automation where visibility and manual control are more important than bulk modification. I am familiar with Google Sheets, Google Apps Script, data scanning and validation logic, duplicate detection, conditional formatting via scripting, button- and trigger-based macros, and clean, reusable script design that leaves existing data untouched. For this project, I would create a simple Apps Script that scans the email column, identifies duplicates, and highlights every repeated email in red only—without deleting or altering any rows—triggered via a button or shortcut and easily reusable across future sheets. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$30 CAD in 7 days
4.7
4.7

As an experienced Mechanical Engineer and data specialist, I possess all the skills necessary to complete your Google Sheets project accurately and efficiently. Not only am I comfortable with using VBA to automate tasks, but I also have a strong background in Python, making me highly proficient in manipulating data, such as scanning and identifying duplicates - exactly what your project entails. One of the things that set me apart from other freelancers is my ability to bridge technical know-how with operational requirements. I understand that you want full control over the duplicate removal process, and this is why my proposed 'highlight-only' approach aligns perfectly with your needs. My method not only identifies duplicates but also ensures you get to choose which contact entry to keep and which to remove - all while leaving the rest of your worksheet intact.
$150 CAD in 7 days
4.9
4.9

Highlight Duplicate Emails in Google Sheets Hello, I can create a lightweight macro for your Google Sheets on Mac that: Scans your contacts sheet for duplicate email addresses Highlights duplicates in red without deleting anything Leaves all other data and formatting untouched The deliverable will be a ready-to-use Apps Script module (or macro-enabled workbook if preferred) with clear installation and usage instructions, so you can easily reuse it in future sheets. I focus on reliability, simplicity, and easy deployment, and can deliver this quickly. Best regards,
$155 CAD in 1 day
4.5
4.5

Hi there, I understand the importance of maintaining the integrity of your contact list, and I'm confident in my ability to create the lightweight macro you need. With my experience in Google Apps Scripts and VBA, I will develop a solution that scans your Google Sheets for duplicate email addresses and highlights them in red, allowing you to manage duplicates effectively without altering any other data. I'll ensure you receive a ready-to-use module, complete with clear installation and usage instructions, so you can easily integrate it into future projects. Thanks,
$120 CAD in 1 day
3.5
3.5

With my dynamic experience as a Software Engineer and my proficiency in languages like Python, I am the perfect fit for your project. My expertise in Data Processing enables me to skillfully navigate through large amounts of data, identifying patterns and instances of duplication quickly and effectively. I understand the value of empowering my clients with the ability to make informed decisions about their data, which is precisely what you require. In previous projects, I have developed similar scripts that efficiently identify duplicates within datasets without altering any other important information. My work ethic aligns with your need to retain complete control over your contact rows; thus, I will create a simple and lightweight macro that only highlights duplicate email addresses while keeping everything else intact. Additionally, I am well-versed in VBA module development and comfortable providing detailed installation and usage notes for a smooth integration process. My goal is not just to provide you with a ready-to-use solution but to ensure that you understand it thoroughly so that you can replicate it in any future files without any concerns or hesitation. Let's work together to votre your data consistency and optimization needs!
$200 CAD in 3 days
3.6
3.6

With my broad experience in data management and handling large datasets, I believe I am the perfect fit for this task. I have a wealth of knowledge in Excel Macros, Excel VBA, and Google Apps Scripts, as well as impeccable skills in Google Sheets and Visual Basic. Your request for a lightweight macro that can effectively scan your contacts worksheet to highlight duplicated email addresses without deleting any information aligns perfectly with my skillset. Throughout my career, I have continually sought efficient ways of processing and organizing data. I can strategize an approach that will quickly identify and highlight duplicated entries in red whilst keeping every other part of your workbook intact. My methodical and detail-oriented nature ensures that your dataset will be accurately processed, allowing you to make informed decisions about which contact rows to retain or remove. Overall, my goal is to save you time and frustration by delivering a ready-to-use VBA module (or macro-enabled workbook), complete with installation and usage notes for easy future integration. Moreover, my thorough understanding of Mac Google Sheets guarantees a smooth performance of any script or code I deliver. Choose me today for an efficient and dependable solution to your data duplication challenge!
$50 CAD in 3 days
4.0
4.0

Hello there, As an experienced researcher and data scientist, data analyst, my qualitative analysis skills perfectly align with your job requirements. My profound knowledge of Python and R Studio guarantees fast learning and adaptation to new tools. Moreover, my advanced skills in Excel make me highly competent in handling large datasets efficiently—making me proficient in extracting the best insights from your transcripts. I fully comprehend the importance of working papers and meticulously preparing financial statements, especially within strict timelines. my sharp analytical skills and extensive knowledge of excel ensure that I leave no stone unturned in making sure every detail is covered under evaluation. My passion for quality, originality and meeting deadlines makes me an excellent choice for this project. I cannot wait to prove my extensive skills to you through providing actionable insights that will help guide your decision making regarding domestic charter flights. Best Regards
$30 CAD in 1 day
3.4
3.4

Hi, noticed that you are looking for a skilled developer with experience in vba. I can get it done as I have previously worked on projects involving building vba macros for doing operations. So I'm sure that with my experience in that I'll be able to get it done within a short amount of time. So let's talk more in DM.
$100 CAD in 2 days
3.0
3.0

Ile Bizard, Canada
Payment method verified
Member since Mar 20, 2015
$30-250 CAD
$30-250 CAD
$10-30 CAD
$30-250 CAD
$100 CAD
$250-750 USD
$15-25 USD / hour
₹100-400 INR / hour
$2-8 USD / hour
₹1500-12500 INR
₹1500-12500 INR
£250-750 GBP
$2-8 USD / hour
₹12500-37500 INR
$30-250 NZD
₹600-1500 INR
$250-750 USD
$10-30 USD
$100-300 USD
£250-750 GBP
₹600-1500 INR
$2-8 USD / hour
₹1500-12500 INR
₹600-1500 INR
₹1500-12500 INR