Overview
The QA Report Splitter is a VBA macro that splits batch QA reports from a new system into individual language files matching the legacy format. This tool was created after a company-wide system change caused hours of overhead across all QA teams—work that previously took 10 minutes suddenly required hours of manual tab-clicking.
After proving its value, the tool was adopted by the lead developer and absorbed into the company-wide QA platform. It became the standard process for all QA teams.
The Problem
The System Migration Crisis
After a decade with one QA system, the company migrated to a new platform. The new system exported all languages in a single batch file instead of individual files. This confused clients expecting individual files and required QAs to manually click through 26+ tabs, turning a 10-minute task into hours of work.
System Change Impact
Manual Process (Before)
[Batch Report] ├── Tab: English ├── Tab: German ├── Tab: French ├── ... (26 tabs) └── Manual: Click each, copy, paste, save, rename × 26 Time: HOURS of repetitive work
This affected every QA team across the entire company. What was once a 10-minute task suddenly required hours of tedious manual work, impacting productivity and morale across all teams.
The Solution
Created a macro that reads the new batch file format, identifies each language tab, extracts and formats individually, names according to legacy convention, and produces client-ready deliverables—all in a single click.
Core Capabilities
Format Mapping
| New System | → | Legacy Format |
|---|---|---|
| Combined header | → | Split headers |
| Metric columns | → | Standard order |
| Date format | → | Client preference |
| Score display | → | Percentage format |
Automated Process (After)
[Run Splitter] → [Output Folder]/ ├── English_QA_Report_2025-01.xlsx ├── German_QA_Report_2025-01.xlsx ├── French_QA_Report_2025-01.xlsx └── ... (26 files, 30 seconds) Time: ~10 MINUTES total
Workflow
Basic Operation
Splitting Logic
Load batch file
Identify worksheets
For each worksheet: Detect language → Extract data → Apply legacy formatting → Create individual file → Save with proper name
Generate summary
Output Specifications
| Aspect | Detail |
|---|---|
| Files Created | 26 (one per language) |
| Naming | [Language]_QA_Report_[Date].xlsx |
| Format | Legacy system compatible |
| Location | Output subfolder |
Results
| Metric | Before | After | Improvement |
|---|---|---|---|
| Processing Time | Hours | 10 minutes | ~95% reduction |
| Process | 26 languages manual | Batch + split | Automated |
| Impact | Company-wide pain | Solved | Tool adopted |
| Format | Inconsistent | Legacy match | Client ready |