+ Reply to Thread
Results 1 to 2 of 2

Macro to sort column based on the values

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2019
    Posts
    756

    Macro to sort column based on the values

    Hello,

    I wish to create a macro which sorts my column based on the values in it. Once data has been copied into my spreadsheet, column K shows "Priority 1" or "Priority 2".

    I want the macro to sort column K with the Priority 1 cells at the top and then the Priority 2 cells.

    Can anyone help please?


    Regards,


    Chris

    Macro Issue.JPG

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Macro to sort column based on the values

    Can you attach a short Excel sample of your data ...?
    - Battle without fear gives no glory - Just try

+ 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] I have a sort macro. How to add script to preselect rows to sort based on column value?
    By Jasonhouse in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2014, 02:25 AM
  2. Sort Different sections based on values in a column
    By thelegazy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-26-2013, 02:28 AM
  3. [SOLVED] sort column based on number of duplicate values
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2013, 12:35 PM
  4. [SOLVED] sort and delete based on the values in column c and column j?
    By barbibchn in forum Excel General
    Replies: 1
    Last Post: 01-14-2013, 04:25 PM
  5. [SOLVED] Macro to do expanded sort based on column M
    By tiger10012 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2011, 09:02 AM
  6. Sort one column based on values in another column?
    By mogabi in forum Excel General
    Replies: 2
    Last Post: 01-17-2011, 01:26 AM
  7. How do I sort based upon values in another column?
    By Huuuze in forum Excel General
    Replies: 5
    Last Post: 10-27-2010, 10:54 AM
  8. I need a macro that will sort my information based on values in a column
    By theczar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2010, 02:13 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