Re: sort

Thanks.
Since we are at it, is there possible to generate a sequence? For
example I have a excel file and I want to insert a column to the left
and fill that column with a sequence, so that each row is numbered
form 1 though the highest row number? Thanks again.

On Feb 5, 10:52 am, "David McRitchie" <dmcritchie_xl...@xxxxxxxxxxx>
wrote:
sort the minor columns first
D-E-F
then the major columns
A-B-C

More information on sorting:
http://www.mvps.org/dmcritchie/excel/sorting.htm

If you have Excel 2003 then you will have to avoid
the Ctrl+A problem introduced with that version
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#foobar
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



<othell...@xxxxxxxxx> wrote in messagenews:1170650847.913056.25610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
How can I sort the columns in my excel file when it exceeds more than
3? Suppose I have a excel file that has 100 columns and several
thousand rows. How can I sort the file based on 10 columns? Thanks.- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: Running Excel Addin from VBA in Access....HELP!!
    ... You initially build a macro in Excel to do what you want, ... imbeds it in an Excel file of your choosing, then runs it as a macro. ... code that creates an Excel file, ... Dim objUniqueTeams As Object ...
    (microsoft.public.access.modulesdaovba)
  • Re: sort
    ... For the second part of your question on generating a sequence. ... on a page before your sort. ... a single cell selection in a sort is never your friend because ... of magnitude when combined with change of Ctrl+A in Excel 2003. ...
    (microsoft.public.excel.misc)
  • RE: Sorting Alphanumeric data in Excel 2003
    ... sort the numbers and the texts separately. ... In the Excel file, ... the cells are exactly Text now. ...
    (microsoft.public.excel.setup)
  • Re: Real Workaround for Excel Link Bug in 2007?
    ... you'd need the Excel file in the local directory. ... Or did you mean local HDD vs "the same directory as the PPT itself"? ...
    (microsoft.public.powerpoint)
  • Re: Import same Excel ranges from many workbooks
    ... Import Data from that EXCEL File via TransferSpreadsheet" in your suggested ... Dim strTable As String, strBrowseMsg As String ... accept the named ranges from those Excel workbooks without errors. ...
    (microsoft.public.access.modulesdaovba)