+ Reply to Thread
Results 1 to 2 of 2

sorting out values from highest to lowest using VBA

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    59

    sorting out values from highest to lowest using VBA

    Hi guys, I need you help

    I need to set up a piece of VBA code that would take given area of data(titles and values), sort them out from highest to lowest and index them starting from A59 (Titles) and B59(Values).
    I want to use the code for several sheets, where the lenght of the data area may differ, so it would be great if the area of DATA would be a variable specified for example in:

    A53 - The start column of the titles
    B53 - The end column of the titles
    C53 - The start column of the values
    D53 - The end column of the values
    A56 - The row of titles
    B56 - The row of values

    I've included the sample file. In case you don't understand what I mean

    Thank you, any help will be appreciated.*
    samplio.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: sorting out values from highest to lowest using VBA

    Record a macro sorting it, and change the range selected to be sheets("Sheetname").usedrange
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. Sorting by the sum of a group from highest to lowest
    By Boosh1069 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2013, 05:58 PM
  2. Sorting from lowest to highest by specific column
    By smaier69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2013, 12:17 PM
  3. [SOLVED] Excel 2007 : Sorting column by numbers, lowest to highest
    By elryp3000 in forum Excel General
    Replies: 4
    Last Post: 06-07-2012, 11:24 AM
  4. Proper number sorting. Lowest to Highest
    By cturtle in forum Excel General
    Replies: 5
    Last Post: 08-12-2008, 11:29 AM
  5. sorting columns from lowest to highest totals
    By tvi569 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-06-2007, 08:41 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