+ Reply to Thread
Results 1 to 3 of 3

Grouping Rows Based on Values in Another Cell

  1. #1
    Registered User
    Join Date
    01-04-2016
    Location
    viet nam
    MS-Off Ver
    office 2010
    Posts
    5

    Question Grouping Rows Based on Values in Another Cell

    Hi guys, I'm stuck in this case for grouping data. First, i have:
    +Column C: contains total amount money. For example: 50,60,30,100

    Now i will type in Column D the range to group column C. So i type in column D:
    +Column D: D1: >50; D2: <50

    I need VBA code to group the column C based on column D and copy values of column D paste to column B. Any help would be greatly appreciated !!!
    Sample.xlsx
    Last edited by tu.nguyenq512; 01-06-2016 at 12:24 AM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Grouping Rows Based on Values in Another Cell

    Could you include the excel workbook with sample data and the expected resuts? It would help a lot..

  3. #3
    Registered User
    Join Date
    01-04-2016
    Location
    viet nam
    MS-Off Ver
    office 2010
    Posts
    5

    Re: Grouping Rows Based on Values in Another Cell

    I already include the sample !!

+ 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. Grouping rows based on 2 column values
    By anvilofstars in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2015, 12:39 PM
  2. [SOLVED] Grouping Row Values Based On Set Criteria
    By RRa in forum Excel General
    Replies: 6
    Last Post: 06-21-2014, 05:21 AM
  3. [SOLVED] Grouping and then pasting rows based off value in cell
    By hambly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2013, 01:01 PM
  4. Replies: 6
    Last Post: 10-18-2012, 03:10 PM
  5. Grouping rows based on common values
    By jfd456 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2012, 06:31 AM
  6. Replies: 4
    Last Post: 06-28-2012, 07:08 AM
  7. Grouping rows based on column values and comparing row values
    By bernborough in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2010, 10:18 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