Using Sheet names in formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top