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.