Sort by specific word, then reg sort. (VB knowlege NEEDED)
 

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?? :confused:


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

Sort by specific word, then reg sort. (VB knowlege NEEDED)
 

One way would be to use a helper column (No VB knowledge needed). Say
your school names are in column B. In an empty column in row 2 enter:
=IF(B2="Garfunkle","AAAAAAA",B2)
Copy down as needed and then sort by this new column.

Hope this helps
Rowan

Zlord wrote:
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?? :confused: