Results 1 to 1 of 1

Sort groups by alphabetically using the string of a certain cell in that group.

Threaded View

Hizen Sort groups by alphabetically... 05-20-2015, 01:13 PM
  1. #1
    Registered User
    Join Date
    05-20-2015
    Location
    Nebraska, USA
    MS-Off Ver
    2013
    Posts
    1

    Exclamation Sort groups by alphabetically using the string of a certain cell in that group.

    I'm pretty new to programming in Excel, particularly VBA. I have an Excel spreadsheet that I need to alphabetize. However, I need to alphabetize it by a group's heading, not just rows or columns. There's a bunch of buttons and text off to the right that make row operations impossible unless I copy/paste that section (shown in the attached picture) to the other sheet. But copy/pasting in a macro causes issues; like extra buttons.

    C_HEADER
    REV DATE ENG DFT REMARKS
    0.0 01FEB2015 AA BB stuff
    1.0 02FEB2015 AA BB stuff 59763
    1.1 03FEB2015 AA BB stuff^2 sdf
    2.0 04FEB2015 AA BB stuff #$%^&


    A_HEADER
    REV DATE ENG DFT REMARKS
    0.0 01JAN2015 AA BB stuff
    1.0 02JAN2015 AA BB stuff 59763
    1.1 03JAN2015 AA BB stuff^2 sdf
    2.0 04JAN2015 AA BB stuff #$%^&


    B_HEADER
    REV DATE ENG DFT REMARKS
    0.0 01FEB2015 AA BB stuff
    1.0 02FEB2015 AA BB stuff 59763
    1.1 03FEB2015 AA BB stuff^2 sdf
    2.0 04FEB2015 AA BB stuff #$%^&

    How do I do this?

    Some of the troubles I've been having is I'm trying to create a macro but extra buttons keep appearing when the macro executes.

    I've attached a picture of part of the spreadsheet.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can you sort data alphabetically in one particular cell?
    By hawkeye12345 in forum Excel General
    Replies: 23
    Last Post: 10-02-2021, 11:43 PM
  2. How can I sort data alphabetically in one particular cell?
    By Nikolas1988 in forum Excel General
    Replies: 5
    Last Post: 06-06-2014, 08:12 AM
  3. [SOLVED] can i sort data alphabetically in one particular cell?
    By uuthbey in forum Excel General
    Replies: 6
    Last Post: 01-31-2014, 02:28 PM
  4. Function to sort a cell alphabetically with no regard for the data
    By HyperboleJoe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2014, 11:54 AM
  5. Can you sort data alphabetically in one particular cell?
    By MJExcel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 08:57 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1