Robust Excel Macro Fix
Budget: $30 – $250 AUD
I already have every worksheet, range and formula laid out; what I’m missing is a rock-solid VBA routine that will apply them exactly the same way each time I refresh my data. I work in Microsoft Excel and the recorder gives me a script that looks perfect on the first run, but when I bring in new data and launch the saved macro, references shift and the conditional formats go out of sync.
Here’s what the finished code must do:
• Loop through several predefined sheets, drop the right formulas into the right columns and lock them in place.
• Add formula-based conditional formatting that highlights cells whenever a value climbs above my threshold or when specific text appears—no icon sets or data bars, just clean colour fills.
• Keep all rules and references dynamic so that a fresh data import of any length still lands exactly where it should without breaking existing formats.
I’ll hand over the workbook, the templates and every formula, so you can focus purely on writing and testing the macro. I’d like the final deliverable to be a single, well-commented VBA module that I can paste into future files with minimal edits. As soon as it runs flawlessly—same colours, same formulas, no reference drift—we’re done.
I will need to be able to pass it onto other users.
Here’s what the finished code must do:
• Loop through several predefined sheets, drop the right formulas into the right columns and lock them in place.
• Add formula-based conditional formatting that highlights cells whenever a value climbs above my threshold or when specific text appears—no icon sets or data bars, just clean colour fills.
• Keep all rules and references dynamic so that a fresh data import of any length still lands exactly where it should without breaking existing formats.
I’ll hand over the workbook, the templates and every formula, so you can focus purely on writing and testing the macro. I’d like the final deliverable to be a single, well-commented VBA module that I can paste into future files with minimal edits. As soon as it runs flawlessly—same colours, same formulas, no reference drift—we’re done.
I will need to be able to pass it onto other users.