Free VBA Templates Library

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

Calculate Return on Investment with multiple scenario analysis

Create dynamic charts that update automatically with new data

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.

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

Send personalized emails with Excel data

Generate formatted reports with charts and summaries

Generate professional invoices from worksheet data with automatic calculations, VAT handling, sequential numbering, and PDF export. Ideal for freelancers and small businesses.

Create pivot tables automatically with predefined settings

Add, rename, delete, and organise worksheets with advanced options