Macro to copy entries from a file (if they satisfy a condition) and save in a new file

Hi,

I need to copy entries from one consolidated file and split them into different files. I have attached the file containing my data.

What I need to do is copy all the entries for one country and create & save (as country name) a new excel file containing all the entries for that country. My data is all sorted by country name, so a simple 'if' condition to copy all the cells till the country name changes should work. I would also need the heading row (1).

Path to save: C:\Documents and Settings\prabhakarc\Desktop\Caleb

Some ideas that I have: I have created a blank template file with the headings with the name Country_Data, so pasting the copied data into this file and Saving As 'Country name' copied from the consolidated file might work?

Appreciate the help in advance!

Thanks,
Caleb