Kevin,
There isn't any automatic way.
Manully, you could first sort each of your sheets (let's just say you have
two sheets), then transfer the second half of the first sheet to a third
sheet, move the first half of the second to the second half of the first
sheet and re-sort, the move the data off the third sheet onto the top of the
second and re-sort the second. Eventually you will get a small enough subset
of overlap that you can just move the overlap onto one or the other of your
two sheets.
OR
Use a formula that returns a Rank value for each record, and do it by
numbers.
A macro could be used, but would require some work that would only be
worthwhile if you were doing this frequently.
HTH,
Bernie
MS Excel MVP
Kevin Green said:
I have several worksheets of data that I would like to sort however I cant
put them all on one page as there are more thatn 65000 lines which seems to
be the max a worksheet can have. Is there a way to sort all the data across
worksheets as if it was on one page? All of the columns and formats are the
same across pages.
