Advanced Sortting Issue

Please Help!!! I pretty good with Excell, but I don't really know the lingo
so bear with me
Here is what I'm dealing with. I have lets say something that looks like
this below.

A B C D E F G H I J K L M N O P Q R S
Employee Position Employee # Rating
Bob Smith Cheif 1234567 Unlimited
Document Orig Date Exp Date Comment
CPR 1-1-1999 1-1-2002 none
MMD 1-3-1998 1-4-2005 none
First Aid 1-3-1999 1-3-2002 none

Now lets say I have 10 Employee's and want to keep track of when different
"Documents" "Exp". These are merged cells and I can't sort a mreged cell for
some reason.
Now on to the bigger question. Lets say I have 10 of these "fields" (10 of
the same setup as above copied below eachother) I want to sort each
"Employee" by the soonest expiration date.

Thank You
Sean DeBruler

First of all, unmerge those cells. I suggest you workaround it, one
possibly being align as Center Across Selection if desired. And you can
sort by up to 3 different criterions natively if you'd like. Select your
data/column | Data | Sort, pick your criteria(s).

Is this what you're talking about?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"Sean DeBruler" <SeanDeBruler@discussions.microsoft.com> wrote in message
news:1131A25D-6CE0-46DF-A7AE-0E4605A2B1DF@microsoft.com...
> Please Help!!! I pretty good with Excell, but I don't really know the
> lingo
> so bear with me
> Here is what I'm dealing with. I have lets say something that looks like
> this below.
>
> A B C D E F G H I J K L M N O P Q R S
> Employee Position Employee # Rating
> Bob Smith Cheif 1234567 Unlimited
> Document Orig Date Exp Date Comment
> CPR 1-1-1999 1-1-2002 none
> MMD 1-3-1998 1-4-2005 none
> First Aid 1-3-1999 1-3-2002 none
>
> Now lets say I have 10 Employee's and want to keep track of when different
> "Documents" "Exp". These are merged cells and I can't sort a mreged cell
> for
> some reason.
> Now on to the bigger question. Lets say I have 10 of these "fields" (10
> of
> the same setup as above copied below eachother) I want to sort each
> "Employee" by the soonest expiration date.
>
> Thank You
> Sean DeBruler
>
>

Thanks for the info Zack.
I have unmreged all of the cells. now I still have the same "field" for
each "employee" but I want excell to sort automaticly. Because in reality
It's more like 200 employee's. Not just each employee individualy, but eaach
"field" as well. Can this be done.

"Zack Barresse" wrote:

> First of all, unmerge those cells. I suggest you workaround it, one
> possibly being align as Center Across Selection if desired. And you can
> sort by up to 3 different criterions natively if you'd like. Select your
> data/column | Data | Sort, pick your criteria(s).
>
> Is this what you're talking about?
>
> --
> Regards,
> Zack Barresse, aka firefytr, (GT = TFS FF Zack)
> To email, remove the NO SPAM. Please keep correspondence to the board, as
> to benefit others.
>
>
> "Sean DeBruler" <SeanDeBruler@discussions.microsoft.com> wrote in message
> news:1131A25D-6CE0-46DF-A7AE-0E4605A2B1DF@microsoft.com...
> > Please Help!!! I pretty good with Excell, but I don't really know the
> > lingo
> > so bear with me
> > Here is what I'm dealing with. I have lets say something that looks like
> > this below.
> >
> > A B C D E F G H I J K L M N O P Q R S
> > Employee Position Employee # Rating
> > Bob Smith Cheif 1234567 Unlimited
> > Document Orig Date Exp Date Comment
> > CPR 1-1-1999 1-1-2002 none
> > MMD 1-3-1998 1-4-2005 none
> > First Aid 1-3-1999 1-3-2002 none
> >
> > Now lets say I have 10 Employee's and want to keep track of when different
> > "Documents" "Exp". These are merged cells and I can't sort a mreged cell
> > for
> > some reason.
> > Now on to the bigger question. Lets say I have 10 of these "fields" (10
> > of
> > the same setup as above copied below eachother) I want to sort each
> > "Employee" by the soonest expiration date.
> >
> > Thank You
> > Sean DeBruler
> >
> >
>
>
>