I have a 2 column CSV file.
The first column is repeating country names. The second column is state names
I need a macro that will copy the contents for each distinct country into a new CSV file, than do a "Save As" where the file name is equal to the first column.
Likely to be a macro where you are selecting, pasting into a new sheet, and then d...
Skills: microsoft excel, vba