+ Reply to Thread
Results 1 to 3 of 3

Excel macro for sorting rows based on a specific key value in columns.

  1. 04-04-2022, 05:06 AM #1
    GobyWan8983
    GobyWan8983 is offline
    Registered User
    Join Date
    04-04-2022
    Location
    Germany
    MS-Off Ver
    Office 365
    Posts
    2

    Talking Excel macro for sorting rows based on a specific key value in columns.

    Hello guys,

    I am trying to automate an excel table. I would like to sort the rows according to the "X" values in the columns 3 & 4. I have attached a sample file below. The rows should be arranged in a following manner:

    Row 1

    Row 3

    Row 2

    Row 4

    That is, one small edition after one big edition.

    Can someone please help me with it? I would be thankful
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-04-2022, 06:31 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,152

    Re: Excel macro for sorting rows based on a specific key value in columns.

    Is the initial sequence always ALL Big followed by ALL Small?
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 04-04-2022, 06:47 AM #3
    GobyWan8983
    GobyWan8983 is offline
    Registered User
    Join Date
    04-04-2022
    Location
    Germany
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Excel macro for sorting rows based on a specific key value in columns.

    No, it is random. There is no defined sequence.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to Automatically Delete Specific Columns/Rows + Formatting + Sorting
    By dizjackson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2017, 05:05 PM
  2. [SOLVED] Automatically sorting rows based on two columns
    By Retroshift in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-30-2017, 05:19 PM
  3. Specific sorting macro for 2 columns
    By eddthebed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2016, 12:13 PM
  4. Excel VBA/Macro: Selecting Specific Columns and Rows in Pivot Table and Formatting
    By rarascon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2013, 03:50 PM
  5. Sorting rows based on values in columns
    By midoindeedo in forum Excel General
    Replies: 1
    Last Post: 08-01-2012, 11:05 AM
  6. Macro to Fill Specific Rows and Columns with Color Based on Cell Value
    By MSmithson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2011, 09:45 PM
  7. Sorting rows based on columns
    By ecology in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-22-2009, 07:32 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1