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

[Zlord]

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

[Rowan Drummond]

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