You would need to copy the data and then insert the name into another
column, sorting by that column as well.

There is no automatic facility

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kirk" wrote in message
...
Hi,

I'm trying to sort a large amount of data, about 2500 lines. I want to
copy
the lines with particular data to another sheet, based on the name of the
sheet, and then sort. Does excel have this capability? If so, HELP!

Thanks for your time