Headers getting lost in multiple sort
 

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

Headers getting lost in multiple sort
 

When you say 'one of the headers' gets left behind', are you implying
that you have two or more header rows, or do you mean one of the
headers in one of the columns of a single header row gets left behind?

Rgds



On Sat, 29 Oct 2005 11:12:41 -0500, mpjoyce
wrote:


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

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Headers getting lost in multiple sort
 

Richard -- Thanks for responding. I don't have the document home with
me over the weekend, but the sorts we do make the corresponding column
headers into row headers. And only one of these row headers gets left
behind once this has been done. Any thoughts on it?

MJ


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

Headers getting lost in multiple sort
 

On Sun, 30 Oct 2005 09:59:02 -0600, mpjoyce
wrote:


Richard -- Thanks for responding. I don't have the document home with
me over the weekend, but the sorts we do make the corresponding column
headers into row headers. And only one of these row headers gets left
behind once this has been done. Any thoughts on it?

MJ

Hi,
I'm still not understanding this. A sort will simply sort the rows
under the column headings. You have the option to include or exclude
the first row as within the sorted data.

When you say you make column headers into row headers, this suggests
you're doing something like transposing a single horizontal row of
column headers into a vertical column of cells.

Perhaps an example might help.......?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Headers getting lost in multiple sort
 

Hi Richard --

Thanks for following up; sorry it's been a couple of days on my end.
The example: when it's published, this report is organized into
Manufacturing Capital and Non-Capital projects, and Non-Manuf. Capital
and Non-Capital projects. The headers for all four of these categories
(I checked and yes, it is all four) are getting left behind at the
bottom of the document. If I knew why this happened, I'd probably
understand better how to fix it.


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

Headers getting lost in multiple sort
 

On Tue, 1 Nov 2005 13:38:57 -0600, mpjoyce
wrote:


Hi Richard --

Thanks for following up; sorry it's been a couple of days on my end.
The example: when it's published, this report is organized into
Manufacturing Capital and Non-Capital projects, and Non-Manuf. Capital
and Non-Capital projects. The headers for all four of these categories
(I checked and yes, it is all four) are getting left behind at the
bottom of the document. If I knew why this happened, I'd probably
understand better how to fix it.

Hi,

If it's not confidential and you want to email the document with a
brief explanation of the steps you go through to arrive at the problem
you're encountering, then I'll happily take a look.

Just leave out the no spam remove this bits in the email address.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Headers getting lost in multiple sort
 

Richard --

Thank you for your kind offer -- and apologies for the delay. The info
in the worksheet is somewhat sensitive, so what I'll need to do is clear
out the entries and send it to you with the headings so that you can see
what they are. I'll do this over the weekend.

MJ


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

Headers getting lost in multiple sort
 

Richard --

I took a look at your posts, and didn't see an e-mail address. Can you
send me that?

Thx --

MJ


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