Results 1 to 3 of 3

VBA to Group Differing Rows

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    4

    VBA to Group Differing Rows

    Hello all,

    I am trying to make a VBA code to group certain rows and can't seem to get the logic right. I have attached a file showing my code, example table, and tables grouped as I intend in 3 different tabs.
    In my real data, the code works for some of the groupings, but skips others.

    I have data in columns 1 and 2. Column 1 is headers, and column 2 is data, I want to group all of the data after each header in Column 1 so that the data in column 2 is hidden in groups and can be expanded and minimized. Each set of column 2 data is of a different size, and each header in Column 1 is different. I've tried to work this out from the similar posts here but can't seem to get it right.

    Thank you very much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  2. [SOLVED] Align cells in differing rows to the same row
    By Bernardo in forum Excel General
    Replies: 3
    Last Post: 01-16-2014, 11:15 AM
  3. [SOLVED] Add Multiple Rows to Differing Variables
    By mattyh77 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2012, 08:40 PM
  4. Summarize Data With Differing Amount of Rows
    By ptp24 in forum Excel General
    Replies: 4
    Last Post: 06-23-2011, 09:33 AM
  5. Replies: 7
    Last Post: 10-18-2007, 11:03 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