Solved Sort Excel File and Copy Specific Ranges into a New Excel

September 6, 2019 at 16:02:39
Specs: Windows 10
I have an excel file with bunch of countries. I'd like to sort the file by country, and then take each data set and copy it into a new file, saved as the name of the country name.

For example, if my original file has Mexico, Chile and Argentina, I'd run the VB script and it would take all lines that have Mexico in column B, copy those lines into a new file and saved the new file as Mexico.xls, it would do the same for all the rest of the countries.

I'm not familiar w/ VB at all, so not certain where to begin.


See More: Sort Excel File and Copy Specific Ranges into a New Excel

Reply ↓  Report •

#1
September 7, 2019 at 09:26:32
✔ Best Answer
Excel questions are best asked in the Office Software forum.

Sorry, I do not have much experience with Excel Macros.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question