Free VBA Templates Library

Import CSV files with automatic data type detection and formatting

Automatically create separate worksheets for each unique value in a column. Perfect for splitting survey data, sales reports, or any dataset by category.

Remove duplicates, clean data formats, and standardise entries

Connect to SQL databases and import/export data with error handling

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

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