Splitting sets of data
 

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.

Splitting sets of data
 

Doable but why not just use datafilterautofilter and leave all in one?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"drumbumuk" wrote in message
...
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.

Splitting sets of data
 

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" wrote:

Doable but why not just use datafilterautofilter and leave all in one?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"drumbumuk" wrote in message
...
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.

Splitting sets of data
 

Use dataadvanced 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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"drumbumuk" wrote in message
...
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" wrote:

Doable but why not just use datafilterautofilter and leave all in one?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"drumbumuk" wrote in message
...
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.

Splitting sets of data
 

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

--

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




"drumbumuk" wrote in message ...
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" wrote:

Doable but why not just use datafilterautofilter and leave all in one?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"drumbumuk" wrote in message
...
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.