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
