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

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 '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
.

Relevant Pages

  • RE: Help; thers got to be a better way :-(
    ... Thank you Michael M. ... Firstly, a suggestion. ... Try inserting a row before the last line of your header. ... Do your sort below ...
    (microsoft.public.excel.newusers)
  • Re: Still need help incrementing a number after resetting it daily to 1
    ... Sorry at one point there was a suggestion to use is as the default in the ... If I add NPedana, I am afraid it will create a unending circle. ... > Michael wrote: ... >> "The expression you entered contains invalid syntax. ...
    (microsoft.public.access.forms)
  • Re: Prayer request
    ... > Buck, does exercise help? ... Thanks for the suggestion, Michael. ... the vertebrae that causes the scar tissue to connect with nerves. ...
    (alt.smokers.pipes)
  • Re: Why not XML based configurationfiles?
    ... >boneheads like Michael see a suggestion and attack everybody who dares to ...
    (comp.os.linux.misc)
  • Re: Nachrichten ID?s / Regeln
    ... Wenn eine Nachricht eintrifft, ... Die Message-ID vergibt der absendende Server, nicht dein Ziel-Exchange. ... steht einfach so im Header. ... Michael Hirmke ...
    (microsoft.public.de.exchange)