Forum Discussion
How to split Excel worksheet into multiple files?
I'm not qualified to directly answer your question regarding VBA and its use in dividing your worksheet up.
I am qualified to ask you "Why?" And I do that not just to be a pain in the neck; rather, although I fully recognize there may be fully justifiable reasons, I also am a defender of the power of Excel to work with large databases, using such things as dates--the basis for your desired splitting--as the basis for looking at and analyzing effectively subsets within that whole. Breaking it apart, on the other hand, makes it more difficult to do overall or all-encompassing analysis, which you also might want to do.
So you begin your posting with this statement, "I need to split a worksheet with 10,000 rows into multiple Excel files based on the dates in column D," and I just am asking whether you really NEED to do that. You give no reason. As I said, there may be a perfectly valid reason. But in general--for others who come here to the techcommunity site with workbooks consisting of monthly or yearly sheets--you'll see many a recommendation to first consolidate those separated sheets into one so as to be able to accomplish the all-encompassing analysis they're trying to accomplish.