+ Reply to Thread
Results 1 to 2 of 2

Using a macro to sort your data in alphabetical order?

  1. #1
    Carrie
    Guest

    Using a macro to sort your data in alphabetical order?

    I want to add information to a worksheet and then sort the data into
    alphabetical order all using a macro.

    Can not seem to be able to get this function to work.

    Can it be done? If so how?

  2. #2
    Fredrik Wahlgren
    Guest

    Re: Using a macro to sort your data in alphabetical order?


    "Carrie" <[email protected]> wrote in message
    news:[email protected]...
    > I want to add information to a worksheet and then sort the data into
    > alphabetical order all using a macro.
    >
    > Can not seem to be able to get this function to work.
    >
    > Can it be done? If so how?


    Select the column(s) where your data is and use Data > Sort. A wizard will
    appear.

    Lets say you have a list of mnames. If you have Name in column A and Tel# in
    column B, you must select both columns before you do the sort so that name
    and phone# match after the sort is done.

    /Fredrik



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1