+ Reply to Thread
Results 1 to 2 of 2

insert group header -- above a group of rows -- based on consistent value within the group

  1. #1
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Excel 2010
    Posts
    126

    insert group header -- above a group of rows -- based on consistent value within the group

    Hi. I have several groups of data in the same sheet. Each group has two blank rows above the first row of data. Each group has column "B" in common (e.g., "Phone" in the example attached). I'd like to add a title/label of "Phone" to the first column in the row immediately preceding the first row of data for that group. I've searched and can't find a simple solution. Thank you for your help, as always.
    Attached Files Attached Files
    Last edited by macrorookie; 02-10-2014 at 05:11 PM.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2003-2010-2013
    Posts
    2,078

    Re: insert group header -- above a group of rows -- based on consistent value within the g

    try the following macro.
    Please Login or Register  to view this content.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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. Need to copy header row in group to all rows below header; stop if blank and repeate
    By jmcaleer10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2013, 11:09 AM
  2. How to Insert New Group in Subtoal Group
    By koolguys4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-22-2012, 02:06 PM
  3. Customised ribbon - displaying a group based on pressing a button in another group
    By micklloyd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2012, 03:55 PM
  4. Sort a group of names based on the group total
    By ron2k_1 in forum Excel General
    Replies: 3
    Last Post: 08-13-2010, 01:16 PM

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