Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating data onto separate worksheet tabs
I have a very long list of data that has key identifying information in the
first column. Any ideas on how to automatically (without cutting an pasting) moving all the data that has the same identifier in the first column onto a separate worksheet tab? Example: A xxx xxx xxx xxx A xxx xxx xxx xxx B xxx xxx xxx xxx C xxx xxx xxx xxx ...... for the above example, I want all the rows that start with A on one tab, then all the rows that start with B on another tab, etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating data onto separate worksheet tabs
Hi uneedpsi113
See http://www.rondebruin.nl/copy5.htm Try http://www.rondebruin.nl/copy5_4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "uneedpsi113" wrote in message ... I have a very long list of data that has key identifying information in the first column. Any ideas on how to automatically (without cutting an pasting) moving all the data that has the same identifier in the first column onto a separate worksheet tab? Example: A xxx xxx xxx xxx A xxx xxx xxx xxx B xxx xxx xxx xxx C xxx xxx xxx xxx ..... for the above example, I want all the rows that start with A on one tab, then all the rows that start with B on another tab, etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating data onto separate worksheet tabs
Wow - thanks!!!
"Ron de Bruin" wrote: Hi uneedpsi113 See http://www.rondebruin.nl/copy5.htm Try http://www.rondebruin.nl/copy5_4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "uneedpsi113" wrote in message ... I have a very long list of data that has key identifying information in the first column. Any ideas on how to automatically (without cutting an pasting) moving all the data that has the same identifier in the first column onto a separate worksheet tab? Example: A xxx xxx xxx xxx A xxx xxx xxx xxx B xxx xxx xxx xxx C xxx xxx xxx xxx ..... for the above example, I want all the rows that start with A on one tab, then all the rows that start with B on another tab, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating worksheets into separate workbooks | Excel Discussion (Misc queries) | |||
Separating carriage return data into separate cells | Excel Discussion (Misc queries) | |||
Generate reports on separate tabs from data in file | Excel Discussion (Misc queries) | |||
Generate reports on separate tabs from data in file | Excel Worksheet Functions | |||
How do I combine data (not consolidate) from separate tabs to one? | Excel Discussion (Misc queries) |