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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!