Hi,

I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort because
doing 'DataSortw/ Header' only keeps the top line as header. I need to keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki

Nikki,

Insert a new row above the one row of headers that you want to use, then
select one cell in the table of data, do the Data / Sort, etc. and then when
you're done, simply delete the new row.

HTH,
Bernie
MS Excel MVP


"nikki dawn" wrote in message
...
Hi,

I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort
because
doing 'DataSortw/ Header' only keeps the top line as header. I need to
keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki

Hi Nikki
Firstly, a suggestion. Don't post messages with "Help" or similar. Try and
use something that identifies the issue. A number of posters will ignore a
"Help" mesasage line.

Try inserting a row before the last line of your header. Do your sort below
that line and when finished remove the blank row.

Regards
Michael M

"nikki dawn" wrote:

Hi,

I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort because
doing 'DataSortw/ Header' only keeps the top line as header. I need to keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki

Thank you Michael M. I was sure there was a way (and there was!) I tried what
you suggested and it worked for me. I didn't think of it as there was already
a blank row inserted. You saved me a lot of manual labor and it is
appreciated.

As far as the "HELP" goes, I have to have these reports done by Wed. Next
time I will be more patient. I haven't posted that way previously but I also
haven't had any responses previously.

Thanks for not ignoring my "Help" :-D

Nikki

"Michael M" wrote:

Hi Nikki
Firstly, a suggestion. Don't post messages with "Help" or similar. Try and
use something that identifies the issue. A number of posters will ignore a
"Help" mesasage line.

Try inserting a row before the last line of your header. Do your sort below
that line and when finished remove the blank row.

Regards
Michael M

"nikki dawn" wrote:

Hi,

I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort because
doing 'DataSortw/ Header' only keeps the top line as header. I need to keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki

Glad it worked and thanks for the feedback
Regards
Michael M

"nikki dawn" wrote:

Thank you Michael M. I was sure there was a way (and there was!) I tried what
you suggested and it worked for me. I didn't think of it as there was already
a blank row inserted. You saved me a lot of manual labor and it is
appreciated.

As far as the "HELP" goes, I have to have these reports done by Wed. Next
time I will be more patient. I haven't posted that way previously but I also
haven't had any responses previously.

Thanks for not ignoring my "Help" :-D

Nikki

"Michael M" wrote:

Hi Nikki
Firstly, a suggestion. Don't post messages with "Help" or similar. Try and
use something that identifies the issue. A number of posters will ignore a
"Help" mesasage line.

Try inserting a row before the last line of your header. Do your sort below
that line and when finished remove the blank row.

Regards
Michael M

"nikki dawn" wrote:

Hi,

I have several reports that export into .xls spreadsheeets from SAP. They
always export with multiple header lines which makes it hard to sort because
doing 'DataSortw/ Header' only keeps the top line as header. I need to keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki

As was mentioned. HELP will generally get you LESS response than a
meaningful subject line and a complete explanation of what you want along
with your excel version.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nikki dawn" wrote in message
...
Thank you Michael M. I was sure there was a way (and there was!) I tried
what
you suggested and it worked for me. I didn't think of it as there was
already
a blank row inserted. You saved me a lot of manual labor and it is
appreciated.

As far as the "HELP" goes, I have to have these reports done by Wed. Next
time I will be more patient. I haven't posted that way previously but I
also
haven't had any responses previously.

Thanks for not ignoring my "Help" :-D

Nikki

"Michael M" wrote:

Hi Nikki
Firstly, a suggestion. Don't post messages with "Help" or similar. Try
and
use something that identifies the issue. A number of posters will ignore
a
"Help" mesasage line.

Try inserting a row before the last line of your header. Do your sort
below
that line and when finished remove the blank row.

Regards
Michael M

"nikki dawn" wrote:

Hi,

I have several reports that export into .xls spreadsheeets from SAP.
They
always export with multiple header lines which makes it hard to sort
because
doing 'DataSortw/ Header' only keeps the top line as header. I need
to keep
them all for my boss.

I have been doing them manually but the 2 new ones he gave me this
morning
contain 37,000 rows each.

Is there a way to sort all and have the first 6 rows be an exception?

Any help is appreciated.

Thanks,

Nikki