
In Progress
Posted
Paid on delivery
I already have a working Excel file, but a few final touches will make it truly reliable. I need three things done on the current workbook: • Tidy-up of the visual layout so the sheets look consistent and print cleanly. • Updates to several formulas that are returning partial or inconsistent results. • A handful of new data fields inserted so future reporting is easier. The workbook is set up to highlight cells whenever predefined conditions occur. When that highlight appears, I want a VBA routine to run automatically and send an email to my managers only—no one else. The trigger logic is therefore already in place; the coding work is to listen for the highlight, collect the relevant row details, and push an email (Outlook is fine) without user intervention. Deliverables • Re-worked Excel file with all formatting, formula fixes, and new fields live. • Fully commented VBA module that monitors the highlight event and emails managers. • A short README or video demo so I can maintain or extend the code later. Everything has to run in desktop Excel (no external add-ins). My expectation is to test the file with a dummy highlight, watch the message arrive in the managers’ inbox, and sign off once that flow is repeatable and stable.
Project ID: 40716356
67 proposals
Remote project
Active 7 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
67 freelancers are bidding on average $343 USD for this job

Hello, I have carefully reviewed the project requirements for the Spreadsheet Tweaks & Email VBA project. I understand the need for tidying up the visual layout, updating formulas, inserting new data fields, and implementing a VBA routine to send emails to managers based on predefined conditions. Let's chat and discuss it further. To handle your project, I will start with organizing the visual layout for consistency and clean printing. Next, I will address the formula inconsistencies and insert the required data fields. For the VBA part, I will create a monitoring module to detect highlights, extract relevant row details, and automatically send emails to managers using Outlook. The deliverables will include a reworked Excel file with all modifications, a fully commented VBA module for email automation, and a README or video demo for future reference. Before signing-off my bid, I would like to ask a question, i.e., how frequently do the predefined conditions for sending emails occur? Best Regards, Aneesa.
$250 USD in 1 day
7.2
7.2

AVAILABLE TO START IMMEDIATELY..,,. I will deliver a professionally formatted Excel file with updated formulas and new data fields, along with a robust, commented VBA solution to automate Outlook email alerts based on cell highlights, plus a README for future maintenance. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$250 USD in 1 day
6.7
6.7

Hi there! Project is very clear to me and I can tidy the workbook, fix formulas, add new fields, and create the VBA automation to detect the highlight and email only the managers through Outlook. I’ll provide the updated Excel file, commented VBA code, and a simple README/demo for maintenance. Thank you.
$251 USD in 1 day
6.9
6.9

Hi, I am an Excel VBA developer with 8 years of rich experience in Excel, Visual Basic, data processing, formulas, macros, and data management. I can clean up your workbook layout, fix inconsistent formulas, add the required fields, and create a commented VBA routine that detects the predefined highlight event, collects the relevant row details, and sends Outlook emails only to the specified managers. I will also provide a short README or video showing how to maintain and test the workflow in desktop Excel. 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.
$250 USD in 7 days
5.9
5.9

Hi, I can make your existing Excel workbook more reliable by fixing the formulas, improving the layout, and adding the new reporting fields without disrupting your current setup. I’ll develop a clean, fully commented VBA routine that detects your existing highlight trigger, captures the relevant row details, and automatically sends an Outlook email only to the designated managers. I’ll test the workflow with dummy highlights to verify that the trigger, data capture, and email delivery work consistently in desktop Excel. You’ll receive the updated Excel workbook, commented VBA module, and a clear README or short demo explaining how to maintain or extend the automation. I can start immediately and focus on delivering a stable, easy-to-maintain solution.
$500 USD in 4 days
6.2
6.2

Hello, I am very interested in your project. I am ready to start now. Please send me a message to discuss more about your project. Thanks and Regards, Everest Technology
$250 USD in 7 days
5.7
5.7

Hello, I’ve read your workbook requirements closely, and the hidden risk here is not just the formulas , it’s making the Excel-to-Outlook flow stable enough that a dummy highlight always results in the right managers getting the right email, without false triggers. I’ve handled desktop Excel automation, formula cleanup, layout standardization, and VBA event-driven routines before, including monitored workbook actions that collect row data and send Outlook emails cleanly. I’ll rework the formatting, fix the inconsistent formulas, add the new fields, and build a commented VBA module that listens for the highlight event and sends emails only to the manager list you define. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. Could you confirm whether the highlight trigger is based on conditional formatting, cell fill color, or a specific cell value? Also, should the email body include the full row or only selected columns? Finally, will the managers’ recipients come from a fixed list in the workbook or an Outlook group? Looking forward to your reply so we can finalize the exact plan. Best regards, Asad
$250 USD in 10 days
5.5
5.5

I can make your existing Excel workbook reliable, maintainable, and ready for repeatable desktop testing. I’ll first standardize the sheet layouts for clean on-screen use and printing, then audit and correct the inconsistent formulas while adding the requested reporting fields without disrupting the current structure. I’ll also develop a fully commented VBA module that works with your existing trigger logic, captures the relevant row data, and sends notifications exclusively to the designated managers through Outlook. The implementation will remain self-contained in desktop Excel with no external add-ins. I’ll test the workflow using dummy highlights, verify that the correct message reaches only the intended recipients, and handle repeat-trigger behavior carefully to support stable operation. You’ll receive the updated workbook, organized/commented VBA code, and concise maintenance documentation explaining how to extend the fields, formulas, recipients, and trigger handling. I’m ready to work directly from your current workbook and deliver a dependable final flow.
$250 USD in 5 days
5.4
5.4

Hi, I got that you are looking for a freelancer to tidy up the visual layout, update formulas, insert new data fields, and create a VBA routine to send emails based on predefined conditions in your Excel workbook. This is what I can help you with, let's chat. My approach is to revamp the visual layout for consistency, enhance formulas for accurate results, and seamlessly insert new data fields for easier reporting. To handle the email automation, I will develop a robust VBA module that monitors highlight events and triggers emails to designated managers using Outlook. The outcome will be a refined Excel file with improved functionality and a fully automated email notification system. As final deliverables, you will receive an updated Excel file with enhanced formatting, corrected formulas, and new data fields. Additionally, you will get a well-documented VBA module for email automation and a README guide for future maintenance. One thing I'd like to confirm before we start: Do you have any specific preferences for the email content or formatting? Looking forward to discussing this project further with you. Regards, Imran
$250 USD in 1 day
5.3
5.3

Greetings, It looks like you need some final touches on your Excel workbook to enhance its reliability and functionality. I can help you tidy up the visual layout for a consistent and clean printout. I’ll also update any formulas that aren’t giving you the results you need and add those new data fields to make reporting simpler. For the VBA aspect, I’ll set up a routine that automatically sends an email to your managers when a cell is highlighted, ensuring it’s seamless and requires no user intervention. I’ll make sure to comment on the code thoroughly, so you’ll understand how to maintain or modify it later. I’m here to make sure your workbook is not just good but truly great! Best regards, Saba Ehsan
$450 USD in 3 days
4.6
4.6

Hi — Bravion here from Cleveland. I understand you need final polish on your Excel workbook with formula corrections, layout consistency, and new data fields, plus a VBA routine to automatically email managers when a cell highlight triggers. Here’s how I can help: • Clean and standardize your workbook’s visual layout for consistent printing and easy reading • Debug and update formulas to ensure accurate, reliable results across all sheets • Add requested data fields to streamline future reporting and analysis • Develop a fully commented VBA module that detects highlight events and sends automated Outlook emails to your managers only, with no user intervention A couple of quick questions: 1. How many managers should the email be sent to, and do you have their addresses ready? 2. Are there any specific details from the row you want included in the email body or subject line? I’ll also provide a short README or video demo so you can maintain or extend the VBA code easily. Looking forward to making your workbook truly reliable and automated. Happy to discuss details anytime!
$250 USD in 1 day
4.3
4.3

I can take this on and make the workbook reliable end-to-end. I’ll clean up the sheet layout so it prints consistently, fix the formula logic causing partial results, and add the new data fields so reporting stays clean and future-proof. For the automation, I’ll build a fully commented VBA solution that watches the existing highlight trigger, captures the relevant row details, and sends the email only to managers through Outlook with no user intervention. I’ll keep it entirely inside desktop Excel, with no external add-ins. I’ll also provide a short README or demo so you can maintain the file later and verify the flow with a dummy highlight. Should the alert email include the full row, or only the fields you want managers to review? Miguel
$250 USD in 4 days
4.1
4.1

Hi, I am Adeel. I build a lot of workflow automation around Office and email triggers, including Outlook-integrated alerting for teams that need a hands-off notification flow. That is exactly the shape of what you are describing here. For this I would keep the highlight detection as a Worksheet_Change or conditional format check, pull the row context, then push through Outlook's object model so nothing depends on an add-in. Formula fixes and layout cleanup I would do first, since they affect what the email actually reports. I can start this week and would send a short recorded walkthrough alongside the commented module so you can extend it later. Are the manager email addresses fixed, or do they need to be configurable per row?
$250 USD in 3 days
4.1
4.1

With a strong background in data management, Excel, and full-stack development, I am well-equipped to handle the tasks you require. I have spent countless hours not only working on complex Excel spreadsheets but also building robust AI solutions for various industries. This unique blend of skills puts me in the perfect position to deliver your project to your satisfaction. Regarding your file's visual layout, I understand the need for consistency and cleanliness. I'll ensure all sheets are neatly organized and ready for print, giving you a professional output. Additionally, my experience with complex formulas and data processing will enable me to update your spreadsheet's formulas, ensuring reliable results. One of my key strengths is automating processes. From what you've described, it's evident that your project needs an intricate VBA solution. My ability to build fully commented, error-handled code that operates seamlessly is unparalleled. I'll create a VBA module that efficiently monitors cell-highlighting events and triggers automatic email reports without any user intervention. You can rely on me for clean coding practices as well as providing comprehensive documentation for easy future maintenance. Remember, when you choose me, you're selecting a highly experienced professional who can bring your AI vision to reality. Let's set up a meeting so we can discuss your project further, I look forward to being a part of your team!
$500 USD in 7 days
4.3
4.3

Hi there! Your project centers on making your Excel workbook not just functional, but truly robust and automated—ensuring clean visuals, accurate formulas, and seamless notification to managers via Outlook when key conditions are met. As an experienced Excel and VBA specialist, I understand the importance of consistency in layout, reliability in formulas, and the value of automated workflows for timely communication. I’ve delivered similar solutions, from advanced Excel automation to dynamic reporting and email triggers, always with clear documentation for future maintenance. My approach here would be: (1) standardize your sheet layouts for professionalism and print-readiness, (2) audit and update formulas for full reliability, (3) add required data fields for improved reporting, and (4) develop a robust, well-commented VBA module that listens for highlight triggers and sends targeted emails—fully automated within desktop Excel. To ensure the handover is smooth, you’ll receive a concise README or demo video. Would you prefer a macro or event-driven approach for monitoring cell highlights? Also, can you clarify if multiple highlights might occur simultaneously, and should each trigger a separate email? Best Regards, George
$250 USD in 10 days
4.0
4.0

Hello, As a result of reviewing your requirements, I understand you need improvements to an existing Excel workbook while adding reliable VBA automation for condition-based email notifications. I have experience with Excel, VBA/macros, data processing, formula troubleshooting, data management, and automation workflows. My approach would be to first review the workbook structure, clean up formatting and print layouts, fix inconsistent formulas, and add the required fields without affecting existing logic. For the automation part, I’ll create a properly commented VBA module that monitors the highlight condition, captures the required row information, and sends targeted Outlook emails only to the approved managers. I’ll also test the workflow using dummy conditions to confirm the trigger, email delivery, and repeatability before handover, along with a short maintenance guide. A couple of quick questions: • Is the current highlighting based on Conditional Formatting rules or VBA-generated formatting? • Are manager email addresses stored inside the workbook or should they be configured in a separate settings area? I’m available to review the current file and start immediately. Best regards, Carlos
$250 USD in 7 days
4.0
4.0

With a wealth of experience in data analysis and processing, my Excel skills are second to none. I've spent countless hours tweaking, refining, and perfecting spreadsheets to ensure they are user-friendly, consistent, and error-free—exactly what you need for this project. Given your specific requirements of tidying up the visual layout, updating formulas, and adding new data fields, I am confident in my ability to deliver outstanding results that meet your precise needs. One area where I shine is in Excel VBA. The task you have of running a VBA routine to automatically send emails upon predefined conditions aligns perfectly with my expertise. My command of Outlook's integration with VBA will enable me to write you a fully commented script that is reliable and efficient in pushing those crucial emails to your managers without fail. Lastly, as a virtual assistant specializing in data and administrative tasks, I understand the importance of clear communication, meeting deadlines, and providing thorough documentation. As part of my deliverables, you can expect a comprehensive README or video demo that will empower you to maintain or extend the code even after our project ends. Working together on this project will not only tackle its immediate challenges but also provide long-term benefits for smoother reporting and streamlined tasks – exactly what I strive for with every client. Let's get started!
$250 USD in 5 days
4.1
4.1

REVIWED attachmnets------------------>>The key is making the highlight trigger reliable without changing the logic already working in the workbook. I can clean up the workbook, fix the inconsistent formulas, add the new reporting fields, and build the VBA event flow that detects the predefined condition and sends the correct row details to managers automatically. I will keep everything native to desktop Excel, with commented VBA, controlled Outlook email delivery, duplicate-trigger protection, and testing using dummy highlights to confirm the process works consistently. I will also provide a short handover guide so your team can maintain the workbook later. One important question: Is the highlight generated by conditional formatting or by VBA/manual cell formatting? This determines where the VBA trigger should safely monitor the condition. Please ping me to get started and provide you great results. Thanks!!!
$400 USD in 7 days
4.0
4.0

⚠️ If you're not happy, you don’t pay. ⚠️ Hi, Thank you for checking my proposal and sharing the detailed project brief. I can enhance your Excel workbook using VBA and advanced formulas with a clean, functional, and user-friendly design. I will deliver: • Consistent visual layout across all sheets for clean printing • Updated formulas for accurate and reliable results • New data fields for easier future reporting • Fully commented VBA module that triggers email notifications to managers upon cell highlight • Short README or video demo for future maintenance You will also receive a troubleshooting guide to ensure smooth operation. I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal
$400 USD in 7 days
3.8
3.8

Hello!⚡ Thank you for the clear list. A workbook that quietly emails the right people at the right moment is satisfying to build, and I can start now. I recently built an Excel VBA routine that watched worksheet conditions and sent Outlook emails automatically, with a commented module and guide. How I would proceed: 1. Trigger from the condition itself rather than from the colour. Conditional formatting is a display layer and raises no event, so I read the same rule that drives your highlight and fire from that. It also catches rows that change through recalculation, not only typing. 2. Keep a sent flag per row, so managers receive one message when a row first qualifies instead of another every time the sheet recalculates. 3. Keep the manager list on a settings sheet rather than inside the code, so you can change recipients yourself. 4. Automate Outlook with late binding, so the file runs on any machine without broken references, and save as .xlsm with trust settings explained. 5. Fix the formulas, add the new fields, then set print areas, repeating headers and page breaks so every sheet prints cleanly. 6. Commented module plus a short video. Thanks. Hassan
$350 USD in 2 days
4.1
4.1

Schenectady, United States
Payment method verified
Member since Jul 11, 2025
$30-250 USD
$30-250 AUD
$15-25 USD / hour
$30-250 USD
$10-30 CAD
₹12500-37500 INR
$25-50 USD / hour
₹750-1250 INR / hour
₹12500-37500 INR
$50-100 AUD
$30-250 USD
$250-750 AUD
$8-15 USD / hour
₹1500-12500 INR
₹600-1500 INR
$30-250 CAD
₹750-1250 INR / hour
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
₹12500-37500 INR