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?