Excel macro to create multiple files from one file

[Closed]
Report
Posts
1
Registration date
Thursday July 30, 2015
Status
Member
Last seen
July 30, 2015
-
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