Splitting sets of data

  • Thread starter Thread starter drumbumuk
  • Start date Start date
D

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.
 
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 :-)
 
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.
 
Back
Top