+ Reply to Thread
Results 1 to 6 of 6

Macro or VBA to sort values

  1. #1
    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!

  2. #2
    Valued Forum Contributor
    Join Date
    10-12-2021
    Location
    CT
    MS-Off Ver
    365
    Posts
    460

    Re: Macro or VBA to sort values

    Post your workbook, and I will write you a code.

  3. #3
    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

  4. #4
    Valued Forum Contributor
    Join Date
    10-12-2021
    Location
    CT
    MS-Off Ver
    365
    Posts
    460

    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.

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,672

    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!!!

  6. #6
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,703
    Last edited by macropod; 05-02-2022 at 06:59 PM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. 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 stacrafty@yahoo.com 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1