Currently i'm using Cut & Paste to cut sections from a massive excel worksheet & then pasting the sections into new excel worksheets & renaming the sheets.

Does anyone know how i can chop my excel worksheet into multiple sheets automatically?

For example. Column A contains hundreds of country codes. The first 80 rows contain country code USA.

Then row 81 to 141 change to country code IRE & so on....

When the country code changes i need to chop those country rows into a new worksheet.

Id appreciate anyones help,
thanks