[andymac]

Originally Posted by ctorg

What I do when I work on Lahman is divide it up into two or three files in notepad, then sort each file how I want in Excel. I then use Excel to recombine the files in the way I want, still divided up, and save as separate files again.

For instance, let's say the batting stats are sorted by year, and you want them sorted by name. In notepad, divide the batting file into three separate files by cutting in pasting. Then open each one in Excel and sort it by name. Then copy, say, A thru J from each into a new Excel spreadsheet, then K thru P, then Q thru Z (just randomly picking letters here). Then sort each of those new spreadsheets by name and close them. Then, if that's all you wanted to do, open them in Notepad and recombine them.

Hopefully that makes some sense. I've done a lot of this stuff, so I might be leaving out things I do automatically.

Excellent idea, this will save me a ton of time. Thanks!