Splitting sets of data

[drumbumuk]

Hi All

I have an XL spreadsheet labelled 'English' in which is a contact list of
all contacts that speak English. One column is labelled Country. I want to
split out each Country and place it's respective contacts in it's own
worksheet - so I am left with one worksheet per country.

Really appreciate any assistance.

 

[Don Guillett]

Doable but why not just use data>filter>autofilter and leave all in one?

 

[drumbumuk]

Hi Don

Thanks for that. Been there. Boss wants each country separately. I am on a
massive cut/paste drive at the moment. And they put me on a time-management
course!

What is the 'doable'? Please

 

[Don Guillett]

Use data>advanced filter to get a UNIQUE list and then use that list in a
looping macro to filter for each and copy to a new sheet. Once set up the
entire list should be done in a few seconds.

 

[Ron de Bruin]

See
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm