It's been a while since I've used Excel beyond fairly basic
spreadsheets, and I'm now in a job where once a month, I update a
worksheet created by someone else. The two of us are the primary
users of the document. There are ten columns, and multiple sorting
options, but the users of the worksheet use just a few of them. The
problem I'm having is that when I do the dual sort (First Priority,
Second Priority) requested by the creator for getting the document back
to her, at least one of the headers gets left behind. I don't know why
this is happening. Can someone explain that, and what I can do to
correct it?

The creator of the document deals with the problem with a
cut-paste-cell merge solution that strikes me as a bit messy, and that
I can't seem to replicate. Is there a cleaner solution?

Many thanks in advance!

MJ


--
mpjoyce
------------------------------------------------------------------------
mpjoyce's Profile: http://www.excelforum.com/member.php...o&userid=28437
View this thread: http://www.excelforum.com/showthread...hreadid=480363