+ Reply to Thread
Results 1 to 6 of 6

Macro or VBA to sort values

  1. 04-27-2022, 09:17 AM #1
    siprian123
    siprian123 is offline
    Registered User
    Join Date
    02-24-2016
    Location
    new york
    MS-Off Ver
    2019
    Posts
    21

    Macro or VBA to sort values

    Hi


    My spreadsheet has 100 values on column B from B6 to B106the values have the below form

    AB, BC, CD, DE

    I need to copy the column D the AB values, in column E the BC values, in column F the CD values, in column G the DE values


    I tried to create a macro however, i didn't succeed. can anyone help?


    Thanks!
    Reply With QuoteRegister To Reply
  2. 04-27-2022, 09:25 AM #2
    carlmon
    carlmon is offline
    Valued Forum Contributor
    Join Date
    10-12-2021
    Location
    CT
    MS-Off Ver
    365
    Posts
    462

    Re: Macro or VBA to sort values

    Post your workbook, and I will write you a code.
    Reply With QuoteRegister To Reply
  3. 04-27-2022, 12:45 PM #3
    siprian123
    siprian123 is offline
    Registered User
    Join Date
    02-24-2016
    Location
    new york
    MS-Off Ver
    2019
    Posts
    21

    Re: Macro or VBA to sort values

    Hi,

    Please see attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-27-2022, 01:38 PM #4
    carlmon
    carlmon is offline
    Valued Forum Contributor
    Join Date
    10-12-2021
    Location
    CT
    MS-Off Ver
    365
    Posts
    462

    Re: Macro or VBA to sort values

    This will do what you're after. Please consider adding reputation if I helped you out.

    *It was brought to my attention that this question is cross-posted on several websites. Please add links to your other posts, per the rules of this forum. Thanks.

    Please Login or Register  to view this content.
    Last edited by carlmon; 04-27-2022 at 01:57 PM.
    Reply With QuoteRegister To Reply
  5. 04-27-2022, 02:34 PM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,167

    Re: Macro or VBA to sort values 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  6. 04-27-2022, 06:22 PM #6
    macropod
    macropod is offline
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Macro or VBA to sort values

    Cross-posted at:
    https://www.msofficeforums.com/excel...rt-values.html
    https://www.mrexcel.com/board/thread...alues.1203432/
    https://www.excelguru.ca/forums/show...to-sort-values

    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Last edited by macropod; 05-02-2022 at 06:59 PM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]
    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. Macro to sort values from a pivot table
    By Adjugate in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-01-2021, 06:58 PM
  2. Macro to sort column based on the values
    By chrisellis250 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2016, 11:57 AM
  3. [SOLVED] Macro inputs values between two numbers and sort accordingly
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-18-2015, 05:09 AM
  4. Excluding Certain Values from an Auto-Sort Macro
    By Cowzilla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2013, 05:24 PM
  5. [SOLVED] Help to Create a Macro that will sort by name and count non-numeric values
    By acamm9 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2012, 01:22 PM
  6. Macro to sort values into three columns
    By deville in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2011, 07:48 AM
  7. Macro to sort values in list without 0's (zeros)
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2006, 08:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1