Automated Excel Column Rearranger tool (VBA Macro)

Column Rearrangement Tool – Excel Macro

What it does: This Excel macro automates the tedious task of rearranging columns from raw data exports (e.g., SAP, ERP dumps) into your preferred reporting format. Instead of manually cutting, pasting, and reordering columns every time you receive a data extract, this tool does it in seconds.

How it works:

1. Define your desired column order in the "Input" sheet (Column A)
2. Paste your raw data into the "Data" sheet
3. Click "Run Rearrangement"
4. Get your restructured output in the "Final Output" sheet – ready to use

Key Benefits:

• Eliminates repetitive manual column sorting
• Reduces errors from copy-paste mistakes
• Works with any column layout – fully customizable
• Saves 10–30 minutes per data pull depending on volume
• No technical knowledge required – just list, paste, click

Ideal For:

• Finance teams processing SAP/ERP data extracts (FBL3N, FBL5N, etc.)
• Accountants preparing reconciliation files
• Anyone who regularly reformats exported data into a standard template

Delivery: Single .xlsm file, ready to use. No installation or add-ins required.