Free VBA Templates Library

Compare data across multiple worksheets with complex matching criteria and conditional logic for advanced data validation.

Automatically remove empty rows and columns from your data range

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

Create a data entry form with dropdown lists, automatic field population, and data validation for efficient data collection.

Extract data from web pages using VBA web scraping techniques

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

Automatically synchronise data between two Excel workbooks with real-time updates when cells change in the master file.

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

Combine data from multiple workbooks into a single master file

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