Alright ladies and gents, I'm back.

I am able to compile several worksheets into one, and then sort that
data.
Works perfectly.

My "employer" now wants me to be able to put a specific word at the top
of the sort, then regularly sort the rest of it.

Want a better walkthrough of this?


Okay, this deals with several attendance subsheets, that are compiled
into one big workbook.

the students all go to different schools.
He wants a specific school to be put first; no matter what, then the
rest of them just sorted normally.

So, say the school he wants sorted first is "Garfunkle".
All of the garfunkle students would be sorted first, then the rest of
the schools/students would be sorted apart from them.

How on earth would I do this??


--
Zlord
------------------------------------------------------------------------
Zlord's Profile: http://www.excelforum.com/member.php...o&userid=27519
View this thread: http://www.excelforum.com/showthread...hreadid=479329