Fix Excel Formulas & Automation
Budget: $30 – $250 USD
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
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