VBA Macro Debugging and Testing

I have a VBA macro that has several issues. It's not executing properly, giving incorrect output, and even throwing error messages. I need an expert in VBA to help me with the following:

- Debug the code: Identify and rectify the root cause of the problem that is preventing the macro from executing as intended.
- Test the macro: After debugging, run the code to ensure it works correctly without any issues.
- Demonstrate the functionality: Provide me a demonstration showing that the macro is now correctly automating the repetitive tasks as I intended.

Skills and experience required:
- Strong expertise in VBA programming is a must.
- Experience in debugging complex VBA code and fixing errors.
- Proficiency in Microsoft Excel, specifically Excel 365.
- Ability to clearly communicate and demonstrate the corrected code.

If you are confident in your VBA skills and can help me with this, please feel free to bid.

Clean up small VBA macro code to ensure it executes correctly. Test and show that is working as per the supplied functional description

Code will be supplied for edit and error fixes
XLSM was supplied to test against
functional operation description supplied