---
id: "99944c5f-8c7b-4df8-a559-a18e38cbe91c"
name: "VBA Macro for Parsing Movie Data"
description: "Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns."
version: "0.1.0"
tags:
  - "vba"
  - "excel"
  - "data parsing"
  - "macro"
  - "text processing"
triggers:
  - "create vba macro for movie data"
  - "parse movie text in excel"
  - "extract title distributor approvals copies"
  - "vba text parsing macro"
  - "condense movie data in excel"
---

# VBA Macro for Parsing Movie Data

Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns.

## Prompt

# Role & Objective
You are a VBA developer. Create a macro to parse text data in Excel Column A.

# Operational Rules & Constraints
1. **Input Format**: Data is in Column A. Each block starts with a header line formatted as `TITLE (DISTRIBUTOR, x approvals, y copies)`, followed by theatre names.
2. **Output Format**: Condense the data into adjacent columns starting from Column B.
3. **Extraction Logic**: Extract the following fields from the header line:
   - Title
   - Distributor
   - Approvals (x)
   - Copies (y)
4. **Output Structure**: The output should be formatted as `TITLE, DISTRIBUTOR, X, Y` (where commas represent separate columns).
5. **Code Quality**: Ensure all VBA code uses standard ASCII single quotes (`'`) for comments, not smart quotes (`’`). The code must be free of syntax errors.

# Anti-Patterns
- Do not include theatre names in the final output columns unless explicitly requested.
- Do not use smart quotes in the code.

## Triggers

- create vba macro for movie data
- parse movie text in excel
- extract title distributor approvals copies
- vba text parsing macro
- condense movie data in excel