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.

Statistical analysis and data validation

Create multiple charts on a single worksheet for comprehensive analysis

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

Send emails with file attachments based on Excel data

Process multiple files and organize workbooks

Create interactive dashboards with charts and key metrics

Complete solution for processing survey feedback: clean data, create individual sheets per person, and generate automated charts with statistics. Perfect for student evaluations, employee surveys, and customer feedback.

Calculate correlations between different data series

Extract calculation chains and formulas from cells to external document, resolving nested references to display final values.

Create what-if scenarios for financial and business modeling