Create different worksheets based on data in a column

Closed
aakash.sharma Posts 1 Registration date Tuesday September 24, 2013 Status Member Last seen September 24, 2013 - Sep 24, 2013 at 10:37 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 26, 2013 at 02:49 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 26, 2013 at 02:49 AM
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