🚀 Project Overview

This project delivers a fully automated Data Quality Control (QC) System built entirely in Excel VBA. It implements 15+ validation rules, auto-reporting, error logging, and data standardization, enabling non-technical users to run end-to-end QC with simple one-click buttons.

The system was designed to eliminate execution-level errors, reduce manual workload, and improve overall product accuracy.

🎯 Key Features

✅ 1. Rule-Based Data Validation Engine

A modular VBA architecture where each rule is managed by its own macro. Includes:

• Block numbers in restricted fields

• Mandatory fields check (no blanks allowed)

• Prevent values spilling into adjacent cells

• Only HTTPS links allowed

• Only .pdf URLs allowed

• Period required / period not allowed rules

• Duplicate detection per SKU/Product ID

• Standardized formatting (trim, casing, cleaning)

🧪 2. Automated Error Logging

A dedicated helper column (e.g., Error_Notes) is auto-generated to log issues such as:

• “Missing Value”

• “Numbers Not Allowed”

• “Invalid PDF Link”

• “Duplicate Found”

• “Incorrect URL Format”

This makes QC transparent and easy for non-technical users.

📊 3. Automated QC Reporting

The system creates a full QC summary with:

• Count of filled vs. missing values

• Error rate per attribute

• Fill rate percentage

• Accuracy score

• Summary of SKUs with invalid or missing data

• Timestamped QC report sheet

All reports are generated automatically in a new sheet.

📈 Impact & Business Value

• 70% reduction in QC turnaround time

• 40% improvement in overall data accuracy

• 90% fewer execution-level errors

• Enabled analysts to run QC via simple one-click buttons

• Significantly improved workflow speed and reliability

🛠️ Tech Stack

• Excel VBA

• Dynamic column matching (Application.Match)

• Error handling (IsError, On Error Resume Next)

• String processing (Split, Trim, Replace, InStr, Mid)

• Dictionaries (optional enhancements)

• UserForms for UX (optional)