Excel Macro Automation Needed
Budget: $10 – $30 CAD
I have a worksheet that I update frequently and I’d like a single, easy-to-run VBA macro that tidies everything up for me in one click.
Here’s what the macro must do, in the exact order listed:
• Turn the entire header row blue so it stands out.
• Alphabetically sort all rows A-to-Z (no special multi-key sorting; a simple full-sheet sort is fine).
• Locate every weight field currently stored in kilograms, multiply the values to convert them to pounds, and rename the corresponding header to “Lbs.”
• Format Column AC as Accounting so all monetary figures align cleanly.
• Finally, read Column A, split the data by client name, and save each client’s records to its own workbook (file names can follow the client name).
A straightforward, well-commented VBA module that I can drop into the file is all I need. Please keep the code clean, avoid hard-coding file paths, and add a few comments so I can adjust ranges later if required.
Price for the task is low however you can take up to one week time.
Here’s what the macro must do, in the exact order listed:
• Turn the entire header row blue so it stands out.
• Alphabetically sort all rows A-to-Z (no special multi-key sorting; a simple full-sheet sort is fine).
• Locate every weight field currently stored in kilograms, multiply the values to convert them to pounds, and rename the corresponding header to “Lbs.”
• Format Column AC as Accounting so all monetary figures align cleanly.
• Finally, read Column A, split the data by client name, and save each client’s records to its own workbook (file names can follow the client name).
A straightforward, well-commented VBA module that I can drop into the file is all I need. Please keep the code clean, avoid hard-coding file paths, and add a few comments so I can adjust ranges later if required.
Price for the task is low however you can take up to one week time.