+ Reply to Thread
Results 1 to 3 of 3

Selected rows sorted by column H's data's colors

  1. #1
    Forum Contributor
    Join Date
    06-23-2005
    Posts
    253

    Selected rows sorted by column H's data's colors

    VBA that will sort selected rows by column H's data's colors of Red, Black, or Green. In other words,
    cell H1's data will be Black, H2's data will be Green, H3's data will be Green, etc & whole row will be moved to a section of it's H's column's data.

    For example:

    Unsorted column H's data colors of rows selected:
    Black
    Green
    Green
    Black
    Red
    Green
    Red

    Sorted column H's data colors of rows selected:
    Black
    Black
    Green
    Green
    Green
    Red
    Red

    I really would appreciate help. Thanks mikeburg

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,952

    Re: Selected rows sorted by column H's data's colors

    I don't know what you mean by "data colors". Are you talking about font colors or cell fill colors or do the cells have the actual words "red", "black" and "green'?
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    06-23-2005
    Posts
    253

    Re: Selected rows sorted by column H's data's colors

    Sorry, I mean column H has actual figures or words that are "red", "black", and "green".

    Thanks a bunch. mikeburg

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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