Tutorials

Excel Macros & Google Sheets for Rights Management

Practical, step-by-step guides to automate your catalog management workflows. Every tutorial includes copy-paste code and downloadable files.

Excel Macros advanced

Excel Macro: Bulk Validate EIDR and ISAN Identifiers in Your Title List

VBA macro that validates EIDR and ISAN identifier formats and checksums across your entire catalog, flagging invalid entries for correction.

Apr 20, 2026 · 10 min read

Google Sheets beginner

Google Sheets AppScript: Build a Rights Expiry Alert System in 30 Minutes

Complete AppScript tutorial for building an automated rights expiry alert system that sends email notifications 90, 60, and 30 days before rights expire.

Apr 18, 2026 · 12 min read

Excel Macros intermediate

Excel Macro: Auto-Generate Avails Reports from Your Rights Grid

VBA macro that transforms a rights grid into formatted avails reports grouped by territory, ready to send to buyers or upload to platforms.

Apr 16, 2026 · 10 min read

Google Sheets beginner

5 Google Sheets AppScript Automations Every Catalog Manager Needs

Copy-paste AppScript snippets for territory code validation, duplicate detection, rights window overlap checking, expiry alerts, and auto-sorting.

Apr 14, 2026 · 12 min read

Excel Macros intermediate

How to Build an Avails Tracker in Excel That Actually Scales

Step-by-step guide to building a multi-territory avails tracker in Excel with VBA macros for filtering, validation, and automatic expiry highlighting.

Apr 12, 2026 · 15 min read