I want to split a data dump into multiple files.......
Posted by Dave on January 11, 2002 6:15 AM
When i output from our database, all the data comes out as one file. I would like to find a way to split the one file up into separate files depending on a value in column A.
would idealy be split into three files (called 105227"originalfilename".xls,104268"originalfilename".xls and 102924"originalfilename".xls) each containing only data with the same value in column A. If you see what i mean. It's harder to explain than it should be!
Both the number of different values in A and the number of total records can vary, as will the original file name of the file i run the macro on so, they need to be variables i guess, but, i dont know what the code would be!
And hints, tip or code sugestions greatly appreciated!