| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
| show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
| 3 Different Data Sets | Charts and Charting in Excel | |||
| how do i link up 2 sets of data into 1 set of data in excel | Excel Worksheet Functions | |||
| help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
Linear Mode
