Debug Excel Macro Automation

The workbook I rely on daily contains an existing VBA macro that should handle several automation steps for me, yet its current logic is off and the tasks don’t complete in the right order—or sometimes not at all. I need a developer who can step through the code, identify exactly where the flow breaks down, and rewrite those sections so the automation runs reliably every time the file is opened or the button is clicked.

Here’s what I expect once the job is done:
• The macro executes its full task sequence without manual intervention or unexpected stops.
• Any loops, conditional branches, and object references are cleaned up so they’re easy to maintain.
• I receive the updated workbook plus a brief changelog (commented in-line or a separate note) outlining what you fixed and why.

If you’re comfortable with VBA, breakpoints, and quick-but-safe code refactoring, I’m ready to share the file and walk you through the failing routine.