That is the problem. What you write makes sense. I'm just wondering why you
can choose the planner from the drop down filter arrow and when you choose
sort descending using the same arrow in the planner column, it doesn't work.
I actually found that highlighting all the rows and doing a Data/Sort works.
I'm just trying to make this as easy as possible. Any other suggestions?

"Ron Coderre" wrote:

Not sure what you mean by "mixing up the lines".
Is only the Vendor column sorting and the other
columns retain their positions so they don't match
the Vendors?

That would indicate that ONLY the vendor column is
being selected for the sort. In that case, Excel would
display a pop-up asking if they want to expand the
sort range to include the rest of the data
.....which they should allow.

Does that help?
Or do you have a different problem?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Lackey" wrote in message
...
I have a spreadsheet for work orders. The columns are WO#, Date, Planner,
Vendor, Bldg, Room, Equip#, Date Entered, PO#. Each Planner uses the
automatic filter to see the line items that belong to them. They then
would
like to be able to sort by vendor alphabetically. This is the part that's
not
working. It seems to be mixing up the lines. Can someone please help?
Thanks.