Split Excel Sheet Data into mutliple files based on two criteria
Hi Excel Gurus,
I want to split excel sheet data into multiple workbooks based on two criteria.
Like....
70001-70002.xlsx
70001-70003.xlsx
70001-70004.xlsx
70001-70005.xlsx
70002-70001.xlsx
70002-70002.xlsx
70002-70003.xlsx
70003-70001.xlsx
70003-70002.xlsx
70003-70003.xlsx and so on...
Thanks in Advance
-Saleem
Hi saleembasha
This Code is in the attached and appears to do as you require. It takes a bit of time to process all the combinations (~28 seconds on my Platform).
CTRL + x will fire the Code.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hi John
Thank you so much. It is working as per required. I appreciate you logical approach towards the solution.
Saleem Basha
You're welcome...glad I could help. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks