Free VBA Templates Library

Automatically log all changes to specific cells with timestamp, user, old value, and new value for complete audit trail.

Comprehensive data quality assessment and validation

Use icon sets to create visual status indicators based on cell values

Automatically filter table data based on values entered in specific cells with real-time updates and multiple filter criteria.

Advanced find and replace with multiple criteria and formatting options

Split text in cells based on delimiters like commas, spaces, or custom characters

Manage and use email templates for consistent messaging

Convert multiple Excel files to PDF format with custom settings

Organise files into folders based on criteria like date or content

Import TXT or CSV files with custom column delimiters and save as formatted Excel workbook with automatic data type detection.

Track expenses against budgets with automatic variance calculations, alerts for overspending, and monthly comparison reports.

Create and submit expense reports with receipt categorisation, policy validation, approval workflows, and monthly summary exports. Supports multiple currencies and mileage calculations.