Headers getting lost in multiple sort

M

mpjoyce

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
 
R

Richard Buttrey

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



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
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
M

mpjoyce

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
 
R

Richard Buttrey

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
Click to expand...

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
__________________________
 
M

mpjoyce

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 int
Manufacturing Capital and Non-Capital projects, and Non-Manuf. Capita
and Non-Capital projects. The headers for all four of these categorie
(I checked and yes, it is all four) are getting left behind at th
bottom of the document. If I knew why this happened, I'd probabl
understand better how to fix it
 
R

Richard Buttrey

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.
Click to expand...

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
__________________________
 
M

mpjoyce

Richard --

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

M
 
M

mpjoyce

Richard --

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

Thx --

MJ
 
Top