Forum Discussion
How to split Excel worksheet into multiple files?
Hi, How do I split an Excel worksheet with 10,000+ rows into multiple Excel files based on the values in column D via a Macro/VBA? The file has 9 columns (A:I), I also need the split files to automa...
Can you upload a sample file to work with and another file which shows the desired output you are trying to achieve?
Do you want to run the macro from Excel itself or from another application like Access?
- I have 15,000 lines of data I need to split into 150 worksheets, sorted by Name in Column D. Is there a way to do this in Excel and not requiring additional software/add-in?
