+ Reply to Thread
Results 1 to 4 of 4

Sort & Filter Function

  1. #1
    Registered User
    Join Date
    01-22-2010
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Sort & Filter Function

    Hi,

    I have spreadsheet with a fair bit of data that needs to be sorted from lowest to highest in each column. I have been doing it column by column, selecting sort and filter, continue with current selection etc. I dont want it to expand current selection because it moves all the corresponding rows however the data has been sorted.

    What I want to know, is it possible to highlight the whole spreadsheet and have each column sorted lowest to highest individually? If that makes sense..

    Thanks for any help

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Sort & Filter Function

    What I want to know, is it possible to highlight the whole spreadsheet and have each column sorted lowest to highest individually? If that makes sense..
    It could be done using VBA code, but we would need a sample workbook that . . .

    1. Exactly duplicates the structure of your real WB
    2. Contains representative but non-sensitive dummy data
    3. Manually shows the expected results for clarity

    If you can use a VBA approach, follow the above requirements.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Sort & Filter Function

    hi number46
    possibly
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Sort & Filter Function

    Place this code into a standard module. It assumes row1 on each sheets is a header row.

    Please Login or Register  to view this content.

+ 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