General discussion

Locked

Sorting across worksheets

By ldenight ·
Is it possible to sort in Excel 97 across more than one worksheet in your workbook? If so how would this be accomplished?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Sorting across worksheets

by DKlippert In reply to Sorting across worksheets

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.

Collapse -

Sorting across worksheets

by ldenight In reply to Sorting across worksheets

Poster rated this answer

Collapse -

Sorting across worksheets

by ldenight In reply to Sorting across worksheets

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums