+ Reply to Thread
Results 1 to 3 of 3

Automatic sorting:selected range

  1. #1
    Registered User
    Join Date
    07-07-2008
    Location
    Netherlands
    Posts
    13

    Automatic sorting:selected range

    Hi,
    Is it possible to sort a range automaticly? Meaning, a pre selected range is every time sorted (Descending) when new values are added or changed.

    Ranpak

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    It's possible using a macro:

    - Turn on the macro-recorder ( Tools, Macro, Record new macro)
    - Do the sorting you want
    - Turn o the macrorecorder
    - Copy the macro you created to the VB-object of the workbook you sorted and place it between
    Please Login or Register  to view this content.
    On my site you'll find a description how to copy code for a macro.

    Success
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

  3. #3
    Registered User
    Join Date
    07-07-2008
    Location
    Netherlands
    Posts
    13
    It Works fine. Thanks WintE.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic Sorting
    By paulwelburn in forum Excel General
    Replies: 1
    Last Post: 06-09-2008, 09:11 AM
  2. automatic sorting multiple columns
    By kunesbt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2008, 05:06 PM
  3. Sorting with 6 columns
    By LewR in forum Excel General
    Replies: 3
    Last Post: 07-05-2007, 03:00 AM
  4. Automatic Sorting Alphabetically in an Array
    By ronleex324 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2007, 01:41 PM
  5. Automatic sorting
    By greg7468 in forum Excel General
    Replies: 6
    Last Post: 09-20-2006, 12:43 PM

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