Free VBA Templates Library

Create visual Gantt charts from project task data with automatic date calculations, dependency tracking, milestone markers, progress indicators, and critical path highlighting.

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

Create professional purchase orders with supplier lookup, automatic totals, approval tracking, and order history logging. Includes sequential PO numbering and PDF export capability.

Statistical analysis and data validation

Calculate Return on Investment with multiple scenario analysis

Create dynamic charts that update automatically with new data

Create multiple charts on a single worksheet for comprehensive analysis

Automatically highlight duplicate values in a range with conditional formatting

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