Can I split a spreadsheet into multiple files based on a column in Excel 2007?
Posted
by
geofftnz
on Super User
See other posts from Super User
or by geofftnz
Published on 2009-10-19T03:49:07Z
Indexed on
2012/11/28
11:06 UTC
Read the original article
Hit count: 378
microsoft-excel
|excel-2007
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 dont want them changing eachother's data). The file looks something like this:
salesdata.xls
RepName Customer ContactEmail
Adam Cust1 [email protected]
Adam Cust2 [email protected]
Bob Cust3 [email protected]
etc...
out of this I need:
salesdata_Adam.xls
RepName Customer ContactEmail
Adam Cust1 [email protected]
Adam Cust2 [email protected]
and salesdata_Bob.xls
Bob Cust3 [email protected]
Is there anything built-in to Excel 2007 to do this automatically, or should I break out the VBA?
© Super User or respective owner