FG

Can I split a spreadsheet into multiple files based on a column in Excel 2007?

Fresh3 days ago
Mar 15, 2026145341 views
Confidence Score0%
0%

Problem

Is there a way in Excel to split a large file into a series of smaller ones, based on the contents of a single column? eg: I have a file of sales data for all sales reps. I need to send them a file to make corrections and send back, but I dont want to send each of them the whole file (because I don…

Error Output

RepName          Customer        ContactEmail
Adam             Cust1           admin@cust1.com
Adam             Cust2           admin@cust2.com
Bob  …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Can I split a spreadsheet into multiple files based on a column in Excel 2007?

Low Risk

For posterity, here's yet another macro to tackle this problem. This macro will go through a specified column, top down, and split to a new file whenever a new value is encountered. Blanks or repeated values are kept together (as well as total rows)…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment