Re: Sorting the spreadsheet!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In xl2003, you can apply data|filter|autofilter to the range and use the
dropdown arrow to sort your data.

Debra Dalgleish has a technique at her site that adds invisible rectangles in
the headers and then sorts the data by that field when you click on one of those
rectangles.

http://contextures.com/xlSort02.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Dan the Man wrote:

I'm very familiar with highlighting the document area, and choosing a column
to sort by depending upon my desired sort criteria (last name, state, etc).
Are there any methods or formulas which are able to automatically sort, and
take into account the rows and columns that I tend to sort by?

I always sort by Last name (column A), and highlight accross several rows
and columns when re-sorting my spreadhsheet (typically between Column A and
AQ, and all rows containing data (currently 1-166-but that continues to
expand).

Typically I do a sort after adding a days worth of data, but it just seems
time consuming to shade the affected area and re-sort manually all the time.
Seeing as Excel does everything but make coffee (lol), I assume that there
may be a quicker or more automatic way to sort.

Thanks!

Dan

--

Dave Peterson
.

Relevant Pages

  • Re: Steering Column Headache
    ... From what I recall it was time consuming rather than ... For this sort of thing its where I find digital cameras really ...
    (rec.autos.makers.vw.aircooled)
  • Re: The ARRL And The Threat To AM
    ... Cheaper and less time consuming. ... With the sort of spineless government we have, ...
    (uk.radio.amateur)
  • Re: HD Full Again?
    ... Then sort the result by size..... ... weeks ago so I did a format and reinstall of XP Pro which after reinstalling and reinstalling all MS Office and other programs they use they were left with 13 gig of a 25 gig HD free. ... I tried manually looking into files and such to see what is using up the space but it is way too time consuming.. ...
    (alt.sys.pc-clone.dell)
  • Re: SNR Target vs SNR Margin ?
    ... very time consuming and frustrating business tracking down this sort of ... The secret, as always with ... troubleshooting, is to be systematic, only change one variable at a time ...
    (uk.telecom.broadband)
  • Ruby in a nutshell
    ... I bought a "Ruby in a nutshell" book, but It does not sort after alphabetical order at library part. ... Time consuming to search around it. ...
    (comp.lang.ruby)