Automate a monthly Excel split with a recipe
The worst part isn't splitting the file once. It's doing the identical filter-copy-paste-format ritual on the 1st of every month — one Reddit accountant clocked it at 8 hours for 50 reports, monthly.
What a recipe saves
A recipe in ReportSplit stores everything about your split: which sheet, how many header rows, which column to split by, how files are named, which groups are excluded (goodbye, TOTAL row), and any custom file names you set.
Next month is one click
When the new month's master file arrives, drop it onto the recipe card. ReportSplit finds your key column by header name — so even if someone reordered the columns, the recipe still works. If a column genuinely disappeared, you get a warning instead of a silently wrong split. Review the preview, click Split, done.
Why not a macro or scheduled script?
Scripts do this too — until the file structure shifts, the macro security policy changes, or the one colleague who understood VBA leaves. A recipe is declarative: it describes what the split looks like, checks the file against it every run, and never needs IT approval to install.