Automation & AI
Stop filtering, copying and saving customer files one by one 😩
This template splits your transactions into a separate Excel file for every customer, automatically.
📂 What's inside
• Data sheet: paste all your transactions (52 example rows included)
• Customer list with transaction count + balance calculated automatically
• Ready-to-paste VBA macro with step-by-step setup
⚡ What the macro does
• Creates one .xlsx file per customer in C:\Statements
• Creates the folder for you if it doesn't exist
• Skips blank rows (works for 1 to 50 customers)
• Auto-fits columns so every file looks clean
• Marks each customer "Saved" when done
✅ No coding needed, just copy and paste
✅ "How to use" tab included
⚠️ Needs desktop Excel (Windows)
Perfect for customer statements, regional reports or sending each client their own data.
More automations daily on Instagram 👉 @mraiguys