Help; ther's got to be a better way :-(

  • Thread starter Thread starter nikki dawn
  • Start date Start date
N

nikki dawn

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 'Data>Sort>w/ 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
 
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
 
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
 
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.
 
Back
Top