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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nikki dawn - 11 Feb 2008 20:50 GMT

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

Reply to this Message

Bernie Deitrick - 11 Feb 2008 21:37 GMT

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,
>
[quoted text clipped - 15 lines]
>
> Nikki

Reply to this Message

Michael M - 11 Feb 2008 22:01 GMT

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

> Hi,
>
[quoted text clipped - 13 lines]
>
> Nikki

Reply to this Message

nikki dawn - 11 Feb 2008 22:24 GMT

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

> Hi Nikki
> Firstly, a suggestion. Don't post messages with "Help" or similar. Try and
[quoted text clipped - 24 lines]
> >
> > Nikki

Reply to this Message

Michael M - 11 Feb 2008 22:30 GMT

Glad it worked and thanks for the feedback
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
[quoted text clipped - 37 lines]
> > >
> > > Nikki

Reply to this Message

Don Guillett - 12 Feb 2008 00:12 GMT

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.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Thank you Michael M. I was sure there was a way (and there was!) I tried
> what
[quoted text clipped - 47 lines]
>> >
>> > Nikki

Reply to this Message