Excel VBA Builder - Enterprise ETL

🌐

Target Excel Environment

Auto-Backup Workbook Before Run Pause between steps (MsgBox) Enable Safe-State Rollback (Undo on Error)

1

Sheet Settings & Multi-File Ingestion

Define the ETL Mode and map external structures.

⚙️ Mode: Standard (Map Specific Files) Folder Consolidation (YTD Loop)

📁 Master Folder Path (Privacy Protected)

🛡️ Your local directory structure will NOT be sent to the AI.

📂

Load Schema / Auto-detect

Drag & drop files here to instantly map structures.

⏳ Analyzing metadata & sample data...

Advanced: Multi-Table Consolidation (Standard Mode)

2

Data Metric Tools

Quarantine bad data into 'Data_Exceptions' before transformations.

🟠 Exceptions Routing

3

Core Structuring & Column Shaping

Alters the physical shape of the remaining good data.

🟣 Column Transformations

Delete completely empty rows (Protects table boundaries) Delete exact duplicate rows (100% match across all columns)

4

Output Objects, Dashboards & Reports

Define calculations, build visual dashboards, and route objects.

5

Presentation & Delivery (PDF Binder)

Configure the Print Rendering Engine and generate PDF Binders.

Global Document Title

Table Styling Instruction

📑 Enable Advanced PDF Binder Generation