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


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
dguillett1@xxxxxxxxxxxxx
"nikki dawn" <nikkidawn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7A493254-2059-4D4C-8C0E-3318A685589E@xxxxxxxxxxxxxxxx
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: Sorting UsedRange of a Worksheet
    ... The "header" in a sort range can only be the top row of the range. ... The following code simply sorts the range starting in cell A3 and tells Excel ... Dim wks As Worksheet ...
    (microsoft.public.excel.programming)
  • Re: Autosort, but keep Row 1 seperate
    ... And one of the options when you sort is to allow excel to guess at the header ... I've figured out how to autosort my columns, but there are two problems: ...
    (microsoft.public.excel.misc)
  • Re: Sort confusion
    ... I always select my entire range first and never let excel guess--just in case it ... excel will guess that the range to be sorted has header rows. ... There's an option under each arrow that allows you to sort the filtered range by ... the 'No header row' button? ...
    (microsoft.public.excel.misc)
  • RE: sorting columns sorts header values too
    ... You can either sort 1 column, ... Excel to 'auto choose' what it is sorting. ... "John C" wrote: ... should be a check box that says My Range has, it may default to NO HEADER ...
    (microsoft.public.excel.misc)
  • Re: Sort Data Base By Column
    ... First Select a cell in the column you want to sort in (this is not ... Excel 2002 that would be Ctrl+A like in ALL applications ... Third, Data, Sort, Column A or as known by the header row ...
    (microsoft.public.excel.newusers)