Free VBA Templates Library

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.

Remove duplicates, clean data formats, and standardise entries

Send personalized emails with Excel data

Send emails with file attachments based on Excel data

Process multiple files and organize workbooks

Generate formatted reports with charts and summaries