Software

Ask something
Discussion Locked

Sorting across worksheets

0 helpful
3 replies

by ldenight

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to sort in Excel 97 across more than one worksheet in your workbook? If so how would this be accomplished?

3 replies

by dklippert

There is not an easy way that I know of. You could write a sorting macro including the needed criteria etc, The easiest way is probably to put it into Access, sort and then return it.
Are these worksheets with more than 65,000 records? If not, theycould be pasted into a common sheet, sorted and then copy paste back.

This discussion is closed to new replies.