Free VBA Templates Library

Build weekly and monthly employee rotas with shift assignments, conflict detection, hours balancing, and printable schedule output. Supports multiple shift patterns and holiday management.

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.

Professional UserForm-based data entry system with field validation, dropdown lists, date pickers, auto-complete, and error prevention. The most requested VBA automation pattern.

Remove duplicates, clean data formats, and standardise entries

Manage stock levels with automatic reorder alerts, stock movement logging, valuation reports, and low-stock notifications. Supports multiple product categories and warehouse locations.

Track employee working hours, overtime, absences, and holidays with automatic calculations, weekly summaries, and exportable attendance reports.

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