Create different worksheets based on data in a column

Closed
aakash.sharma Posts 1 Registration date Tuesday 24 September 2013 Status Member Last seen 24 September 2013 - 24 Sep 2013 à 22:37
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 26 Sep 2013 à 02:49
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 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
26 Sep 2013 à 02:49
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