+ Reply to Thread
Results 1 to 7 of 7

invoke sorting using custom sort list

  1. #1
    Registered User
    Join Date
    05-10-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    invoke sorting using custom sort list

    I'm not sure if this will require use of functions or VBA code, but I'm looking to be able to sort my table using custom sort list I create by selecting a cell from a drop down list.
    Image below illustrates what I'm looking to do.

    133.png

    I would really appreciate any tips.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: invoke sorting using custom sort list

    Hi,

    Welcome to the Forum.

    Can you please post a sample template in excel format rather than image?

  3. #3
    Registered User
    Join Date
    05-10-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    Re: invoke sorting using custom sort list

    I'm not sure if posting the excel will clarify it better, but here it is.
    http://www.mediafire.com/view/v6lv3d...m/example.xlsx

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    27,297

    Re: invoke sorting using custom sort list

    To be honest, you're right - it doesn't help much. But.. people here are more than happy spending time to help you, but very few want to re-type what you've already done!!

    Can you explain a bit more about the rules that you want to apply when different vendors are selected?
    Glenn



  5. #5
    Registered User
    Join Date
    05-10-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    Re: invoke sorting using custom sort list

    What I'm looking to do is to be able to sort my table in different ways based on the Vendor I select.
    So if I select Vendor 1 from the drop down, the table will be automatically sorted using a custom sort list I create.
    Then if I select Vendor 2, then the table gets sorted by a different custom sort list I create.

    Basically I have list of items in inventory, but the order of the items is different on each vendor. I'm looking for a quick way to automatically sort the items depending on which vendor I choose.
    Hopefully I was able to explain it better.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: invoke sorting using custom sort list

    Select the Vendor from column A's list, then click on the heading arrow for what you want to sort by. Custom sorts are not part of the Auto Filter. If you want some other sort selectable by drop down, VBA will likely have to be used.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  7. #7
    Registered User
    Join Date
    05-10-2015
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    4

    Re: invoke sorting using custom sort list

    You're right. I believe I figured it out and it did require some VBA code.
    What I did was I recorded macros that does the custom sort, then created a drop down using Data Validation. I then used Select Case to have each cell from the drop down run the macros I recorded.
    Here's the excel file
    http://www.mediafire.com/view/p8ldtb...a/example.xlsm

+ 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. [SOLVED] How to use custom sort while sorting left to right for entire dynamic used range
    By herbie226 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2012, 11:58 PM
  2. Custom Sort List
    By druid98 in forum Excel General
    Replies: 0
    Last Post: 10-10-2011, 07:51 PM
  3. Excel 2007 : Custom sort not sorting completely
    By Sashabaz in forum Excel General
    Replies: 3
    Last Post: 07-10-2009, 11:49 AM
  4. [SOLVED] Excel sort by Fill Color by custom list sort
    By Dash4Cash in forum Excel General
    Replies: 2
    Last Post: 07-29-2005, 06:05 PM
  5. Custom sorting-sort the names
    By kexcelf in forum Excel General
    Replies: 0
    Last Post: 03-29-2005, 04:18 AM

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