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

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: Autosort, but keep Row 1 seperate
    ... putting it in the sheets coding with everything else related to the autosort. ... of my header was affecting the coding of line 2). ... "Dave Peterson" wrote: ... want it to sort by Status first, ...
    (microsoft.public.excel.misc)
  • Re: Autosort, but keep Row 1 seperate
    ... Why not just sort the range with the data? ... Orangepegs wrote: ... "Dave Peterson" wrote: ... of my header was affecting the coding of line 2). ...
    (microsoft.public.excel.misc)
  • Re: Autosort, but keep Row 1 seperate
    ... If you're sorting by code, the change the code to start the sort range in row 3. ... "Dave Peterson" wrote: ... The formula I'm using is in a cell that is sorted. ... of my header was affecting the coding of line 2). ...
    (microsoft.public.excel.misc)
  • Re: The ultimate luxury ?
    ... It is at this point that a *sort* ... I don't want to quibble over terms here. ... entries in that record is the references header. ...
    (sci.physics)
  • Text-to-columns. Destination:=matrix
    ... I have a macro in which I am trying to sort data. ... a table and every column has a unique header. ... tableLength - 1, ...
    (microsoft.public.excel.programming)