Create different worksheets based on data in a column

Closed
Report
Posts
1
Registration date
Tuesday September 24, 2013
Status
Member
Last seen
September 24, 2013
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
I have a huge worksheet, where I have a data by different countries, I want to split this master data into different worksheets based on the countries, and copy respective country data into those worksheets.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
can be done

list uniuqe list of countries using advanced filter
for each of these countries autofilter source data and copy FILTERED data to a sheet namead that country.

for each atofiltter remoe the filltesr and then autofilter for next contry
0