Using Sheet names in formulas

K

Kirk

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
 
B

Bob Phillips

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)
 
Top