
Completed
Posted
Paid on delivery
NEEDED ASAP! My Excel workbook should be doing the heavy lifting for me, yet everything from column J through BI sits empty unless I fill it in by hand. The intent is for those columns to calculate and display results automatically, but the current formulas are broken. I need you to dive in, trace the logic, and repair or rebuild the formulas so every row populates the moment new source data is entered. If you discover that a quick macro or a smart use of conditional formatting achieves the same outcome more cleanly, feel free to go that route—I’m interested in the simplest, most reliable fix. Deliverables • A working copy of the spreadsheet with columns J-BI updating automatically • A brief change log explaining what was altered (formulas, VBA, rules, etc.) • Confirmation that the solution works on Microsoft Excel (desktop) without additional setup
Project ID: 40483746
68 proposals
Remote project
Active 6 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
68 freelancers are bidding on average $136 USD for this job

Dear Sir, I can start to work immediately. INBOX ME I have just read your project description and I can help you with my experiences. I am able to work in your time zone. I did this kind of project before. I am interested in your project. I'm professional Microsoft Excel Visual Basic expert with 5 years’ experience; I have completed over 100+ Excel VBA, Excel Macro projects for my company. EXPERTISE: Visual Basic, Excel VBA, Excel Macro, Excel Formula, Google Sheets, Automate etc. I am highly confident about that. I can do this work with accuracy. Also, I make sure to give 100% quality and commitment to work. If you like me for this project then I would love to hear from you. Don't hesitate to give me a shout or ask me a question if you have any :) Please kindly drop me a message for further discussion. Thanks Habibullah B
$90 USD in 1 day
7.3
7.3

Hi there, I understand your Excel workbook is intended to automatically populate columns J through BI, but the existing logic has broken, leaving those fields blank unless entered manually. I am confident I can diagnose the root cause and restore a reliable automated solution that updates instantly whenever new source data is added. My approach will be to thoroughly audit the workbook, trace all formula dependencies, named ranges, lookup references, VBA procedures, and conditional logic affecting columns J–BI. I will identify whether the issue stems from broken formulas, incorrect references, disabled calculations, VBA conflicts, or structural changes within the workbook. Based on the findings, I will either repair the existing logic or rebuild it using the most efficient method, whether that involves formulas, VBA automation, Power Query, or a combination of these approaches. My goal will be to ensure every row calculates automatically with minimal maintenance, while keeping the solution fully compatible with Microsoft Excel Desktop and avoiding unnecessary complexity. I will also test the workbook using new sample entries to confirm that all calculations populate correctly across the affected columns. Was the workbook functioning correctly before recent changes, or has this issue existed since the file was originally created? I’m ready to start immediately. Warm Regards, Aneesa.
$100 USD in 1 day
7.0
7.0

Warm greetings! I specialize in Excel automation, VBA, and complex formula debugging with 9+ years of experience fixing broken financial, reporting, and data processing workbooks. Here's how I can help: Trace and repair broken formulas across columns J–BI for full auto-calculation Rebuild logic using robust Excel 365 functions for dynamic row updates Replace inefficient formulas with cleaner VBA or conditional logic where needed Ensure real-time updates when new source data is entered I’ll also provide a clear change log explaining every fix and confirm full desktop Excel compatibility. Can you confirm if the workbook uses structured tables or standard cell ranges?
$140 USD in 7 days
7.3
7.3

Fixing your J-BI formula logic... I see your workbook is failing to automate the heavy lifting, leaving those critical columns empty unless manually updated. Whether the issue is broken dependencies, circular references, or heavy volatile functions crashing the sheet, I will rebuild this to be completely hands-off and instantaneous. Here is my execution plan to get this working cleanly: Logic Audit: I will trace the broken dependencies across columns J through BI to identify exactly why the new source data isn't triggering the auto-calculations. Formula Optimization vs. VBA: I will replace the faulty cells with lightweight, modern formulas (like XLOOKUP or dynamic arrays) so it populates instantly. If the data volume is too large and formulas cause desktop lag, I will deploy a clean, background VBA Worksheet_Change macro to handle the heavy lifting without bloating the file. The Handoff: You will receive the fully automated, desktop-tested workbook and a brief change log detailing exactly which rules or scripts were rewritten. Budget & Timeline: I will deliver this fully repaired and automated workbook for $145 USD within 24 hours. Quick question: Are you running a recent version of Microsoft 365 on your desktop (which allows us to use much faster dynamic array formulas), or do I need to ensure backward compatibility with older Excel versions?
$145 USD in 2 days
7.1
7.1

Hi there, We can trace the workbook logic, repair the broken formulas, and rebuild the calculation flow so columns J:BI populate automatically when new source data is entered. We will review formulas, named ranges, workbook settings, and any existing VBA or conditional rules, then apply the simplest reliable fix and test it in Microsoft Excel desktop. You will receive a working copy plus a concise change log covering what was altered. Best Regards, 8veer
$250 USD in 2 days
6.4
6.4

An Excel vanguard with managerial experience of over a decade specializing in solving these precise issues you're experiencing. I would correct template (Gantt chart for planning) accordingly. You can give project after checking file. It's about finding the root cause and coming up with tailored solutions that fully automate your tasks while keeping simplicity and reliability intact; optimizing those columns from J through BI till automation lifts its burden by lettering them populate automatically. That's why I work natively in VBA on Excel and would gladly explore all available avenues to ensure the most streamlined fix for your project. Whether we need to rebuild formulas, or create swift macros or even smartly apply conditional formatting - I want to assure you that you'll receive a fixed, functionally matured workbook that not only eliminates manual data entry but also provides you with a detailed change log for transparency purposes. Let’s simplify your life one formula at a time!
$120 USD in 2 days
6.5
6.5

Hello, I am an Excel formula repair specialist who will trace the broken logic in columns J through BI and rebuild or replace formulas so every row populates automatically when new source data is entered using clean, reliable functions (or a simple macro if that proves more efficient). I will deliver a working copy where columns J–BI update without manual intervention, provide a brief change log of all alterations, and confirm the solution runs on Microsoft Excel desktop with no extra setup. Please share the current workbook so I can begin immediately. Regards, Zafar
$50 USD in 1 day
6.2
6.2

Hello, I have read your job description and I am interested in your job post. I am ready to start now. Please send me a message to discuss more about your project. Thanks and Regards, Everest Technology
$55 USD in 1 day
5.6
5.6

As a seasoned Excel specialist, I fully understand the frustration and inefficiency that comes with broken formulas and clunky manual processes. I have developed impressive skills in data processing over my professional journey, including deep expertise in Excel, Excel Macros, and Excel VBA. Combining these skills with my innate attention to detail, I'm confident in my ability to trace and rectify any formula errors within your workbook. Efficient automation is at the heart of my craft. Through a meticulous approach, I will not only repair or rebuild the formulas but also assess if alternative strategies like macros or conditional formatting can deliver even cleaner outcomes. My goal is to simplify your process while maintaining reliability and accuracy throughout every task. When you choose to work with me, you're guaranteed a working copy of your spreadsheet with columns J-BI flawlessly updating everything new data is entered. Additionally, I'll provide you with a detailed change log explaining each alteration made along with verification that it works effortlessly on Microsoft Excel without requiring any additional setup. I believe in providing solutions that not only solve immediate issues but also enhance long-term productivity.
$120 USD in 1 day
5.3
5.3

I understand you need to fix broken Excel formulas in columns J through BI of your workbook so they automatically calculate and display results when new source data is entered, eliminating manual input. I recently troubleshot a complex financial model where incorrect lookups were causing similar calculation failures, and I was able to rebuild the core logic, restoring accurate, automated reporting within two days. My approach will involve a thorough audit of your existing formulas, tracing data dependencies to pinpoint the root cause of the errors. I will then rebuild these formulas using standard Excel functions, potentially incorporating dynamic array formulas or helper columns for clarity and efficiency. If a VBA macro offers a more streamlined or robust solution for specific automation tasks, I can develop that as well, ensuring the workbook functions as intended with minimal manual intervention. What is the primary source of the "new source data" that triggers the need for recalculation in your workbook? Ready to start as soon as you confirm scope.
$202 USD in 21 days
5.2
5.2

I am interested in helping you fix Excel formulas and improve your spreadsheet automation to make your workflows faster, more accurate, and easier to manage. I have strong experience working with complex Excel functions including VLOOKUP/XLOOKUP, INDEX-MATCH, IF statements, SUMIFS, and dynamic array formulas. Whether your spreadsheet is returning errors, producing incorrect results, or simply needs optimization, I can quickly identify the issues and correct them. Beyond fixing formulas, I also specialize in automating repetitive tasks using Excel tools such as macros (VBA), Power Query, and built-in automation features. I can help streamline data entry, reporting, and calculations so that you spend less time manually updating sheets and more time focusing on decision-making. My goal is to build efficient, scalable solutions that reduce human error and improve productivity. I am committed to delivering clean, well-documented work with clear explanations so you understand exactly what has been fixed and how the automation works. I am ready to start immediately, and I will ensure your Excel files are reliable, optimized, and easy to maintain going forward. I look forward to supporting your project and providing a long-term solution you can depend on.
$30 USD in 7 days
4.8
4.8

I can jump in right away and fix the workbook so columns J through BI populate automatically as intended, without requiring manual entry. My approach will be to trace the existing logic row by row, identify where formulas are broken or missing, rebuild the formulas where needed, and make sure they auto-fill correctly whenever new source data is entered. If a cleaner solution is possible using Excel tables, structured references, conditional formatting, or a lightweight VBA macro, I’ll implement the most reliable option while keeping the file easy to use on desktop Excel with no extra setup. You’ll receive a working copy of the workbook, a brief change log explaining exactly what was fixed or added, and confirmation that the automation works properly in Microsoft Excel.
$50 USD in 1 day
4.9
4.9

Hi, Broken formulas in a workbook you rely on aren't just frustrating — they quietly undermine every decision made from that data. Let's fix that today. I'll open your file, trace the intended logic across columns J through BI, and identify exactly where the formulas are failing — broken references, wrong ranges, circular dependencies, or missing logic. Then I'll repair or rebuild each one so every row populates automatically the moment new source data is entered, no manual input required. If a macro or conditional formatting rule gets the job done more cleanly than a formula chain, I'll use it — but only where it genuinely simplifies things, not just for the sake of it. The goal is the most reliable solution, not the most complex one. Deliverables will be exactly what you've outlined: a fully working .xlsx file with columns J–BI calculating automatically, a clear change log documenting every formula repaired, rebuilt, or replaced, and confirmation that everything runs on Microsoft Excel desktop with zero additional setup or add-ins. This is marked urgent and I treat it that way. Send the file and I'll get eyes on it immediately. Mudassar
$30 USD in 1 day
4.4
4.4

hi there, i'm ready formulate the final version , willing to start and finish soon today , Best Regards
$145 USD in 1 day
4.9
4.9

Hi I am available now . I have over 15 years of experience in excel and can easily fix the issue. as per requirement, I’ll review the workbook, trace the existing logic, and repair or rebuild the formulas from columns J through BI so they auto-populate whenever new source data is entered. My approach: • Inspect current formulas and dependencies • Identify broken references, missing logic, or inconsistent row formulas • Rebuild formulas where needed using reliable Excel functions • Ensure columns J–BI populate dynamically for new rows • Add conditional formatting or lightweight VBA only if it makes the solution cleaner • Test the workbook in desktop Excel before delivery Deliverables: • Working Excel file with J–BI updating automatically • Short change log explaining the fixes • Confirmation that it runs in Microsoft Excel without extra setup I can start immediately once the file is shared. Thanks Shivani
$80 USD in 1 day
4.7
4.7

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience repairing broken Excel workbooks, rebuilding formulas, and automating row-based calculations, and I'm available to start right now. I bring deep expertise in Excel, Excel VBA, Macros, Visual Basic for Apps, Data Processing, Automation and Data Management with over 10 years of experience. One of the key challenges in this task is tracing the intended logic across columns J through BI and rebuilding it so each row updates automatically as soon as new source data is entered. For this project, I will review the workbook structure, identify missing or broken formulas, repair/rebuild the logic, and use VBA or conditional formatting only if it makes the solution cleaner and more reliable. I will also provide a brief change log and confirm the file works properly in Microsoft Excel desktop without extra setup. I have a couple of quick questions. • Are columns J-BI supposed to follow the same formula pattern for every row? • Can you share one correctly completed sample row so I can match the intended output? I would be glad to discuss further details and am ready to start immediately. Best regards, Carlos.
$30 USD in 7 days
4.3
4.3

Hi there, With a high rehire rate and consistent 5-star feedback, I specialize in resolving complex data management and Excel issues quickly. I understand you need this done ASAP, and I am ready to step in immediately to fix your workbook so columns J through BI update flawlessly on their own. Here is exactly how I will deliver on your requirements: Logic Tracing & Repair: I will dive into the broken formulas across columns J-BI and rebuild them. If a clean, lightweight macro or dynamic array formula proves to be the most reliable and simple fix, I will implement that to ensure the sheet does the heavy lifting the moment new source data is entered. Clear Change Log: Along with the working spreadsheet, I will provide a brief, easy-to-understand document detailing exactly what was altered (formulas, VBA, or rules) so you have full transparency. Desktop Compatibility: I will rigorously test the final file to guarantee 100% out-of-the-box functionality on Microsoft Excel (desktop) with zero additional setup required on your end. Since time is of the essence, I can start diagnosing the file right now. Let’s connect so you can share the workbook, and I will get this fully resolved for you. Best regards, Md. Sahinur Rahaman
$50 USD in 1 day
4.0
4.0

The "heavy lifting" line says it all. Your formulas are breaking down and the automation isn't running the way it should. I can review the workbook, trace where the logic falls apart, and fix or rewrite the VBA so it actually does what you need. Available right now and can turn this around within 24 hours. The bid reflects what is in the post. Once I see the file, the final number may shift based on how much needs to be rebuilt. Want to jump on a quick call?
$150 USD in 3 days
3.5
3.5

Hi, I can fix your excel formulas and automation. Please contact me to discuss details and I will jump on it immediately. Please check reviews when considering. Kind Regards!
$125 USD in 7 days
3.5
3.5

Hi, From correcting broken formulas to building robust, automated workflows, I have the dexterity and comprehensive understanding of Excel, macros, and VBA to achieve your project's objectives efficiently. As a seasoned software engineer, my ability to trace logic and identify efficient solutions is invaluable. Though I'm proficient with a wide range of technologies like React, Vue.js, Node.js, Django, and other modern frameworks which might not be directly applicable here, this highlights my adaptability - an essential trait for debugging and revamping existing code. One of the key reasons my clients entrust their projects to me is my commitment to delivering solid results while simplifying complexity. In this Excel repair and automation project, you can expect the same level of dedication. I will ensure every cell from J through BI updates promptly when new data is entered—either by correctly fixing existing formulas or resorting to macros or conditional formatting when necessary for cleaner results. I can provide clear documentation outlining all the changes made and confirm that everything works seamlessly on Microsoft Excel without additional setup. Ready to explore beyond apparent quick fixes, I'll offer an optimized solution for your immediate needs while considering possibilities for future extensions or scaling if desired.
$80 USD in 1 day
3.3
3.3

Goshen, United States
Payment method verified
Member since Jul 20, 2016
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
$10-30 USD
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
£10-20 GBP
₹750-1250 INR / hour
£1500-3000 GBP
₹100-400 INR / hour
£1500-3000 GBP
₹750-1250 INR / hour
₹600-1500 INR
₹600-700 INR
$750-1500 USD
₹600-1500 INR
$2-8 USD / hour
$250-750 AUD
₹750-1250 INR / hour
₹12500-37500 INR
$30-250 USD
$5000-10000 USD
$15-25 USD / hour