Results 1 to 2 of 2

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

Threaded View

macrorookie insert group header -- above... 02-10-2014, 05:01 PM
p24leclerc Re: insert group header --... 02-10-2014, 10:26 PM
  1. #1
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Microsoft 365
    Posts
    170

    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.

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