Excel macro to create multiple files from one file

Closed
dips_arnav
Posts
1
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 30, 2015
- Jul 30, 2015 at 06:19 AM
I have one excel raw data file. in that i have lots of country name from which i have to select data by country in new excel file means i have to create one file for each county from raw data file . then i have to crate one pivot in that new file. please advise. thanks