Excel VBA Macro - Automate Reports & Data Cleaning

This Offer is for building ONE custom VBA macro in ONE Excel workbook, delivered in 2 days.

EXACTLY WHAT YOU RECEIVE:

- 1 custom VBA macro built in your existing Excel workbook
- A button or keyboard shortcut to run the macro
- Error handling so the macro doesn't crash
- Comments in code for future editing
- Testing with your sample data
- Written documentation (how to run the macro)
- Walkthrough video
- 7 days of free post-delivery support

EXAMPLES OF MACROS I BUILD:

- Auto-format a report (headers, colors, borders, print area)
- Consolidate data from multiple sheets into one master sheet
- Clean data (remove duplicates, trim spaces, fix dates)
- Split one sheet into multiple sheets by category
- Send an automated email from Excel (Outlook integration)
- Generate a PDF report and save it to a folder
- Compare two sheets and highlight differences
- Import a CSV file and format it automatically
- Create a pivot table and chart on demand
- Auto-fill a template with data from a master sheet

HOW IT WORKS (2 days):

Day 1: You describe the task + share sample workbook. I confirm scope.
Day 2: I build, test, and hand over the macro with documentation + walkthrough video.

WHAT IS NOT INCLUDED:

- More than 1 macro (available as add-on)
- New Excel workbook design from scratch
- Power Query or Power BI development
- Excel add-in (.xlam) distribution
- Macros that work on Excel for Mac (Windows only by default — ask before ordering)
- Google Sheets scripts (separate Offer)
- Database connections beyond Excel/CSV

REQUIREMENTS FROM BUYER:

- Your existing Excel workbook (.xlsm or .xlsx)
- Written description of the task you want automated
- Sample data (real or dummy) for testing
- Confirmation you're using Windows Excel (not Mac)
- Your Excel version (2016, 2019, 2021, or 365)

This is a fixed-price, fixed-scope service. Delivered in 2 days. No hourly billing. Source code is yours to keep and edit.