+ Reply to Thread
Results 1 to 7 of 7

insert a row to every group and change color of every top row of group

  1. #1
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    insert a row to every group and change color of every top row of group

    hi ,all


    i have some code that groups data works great. just wondering is possible to copy top row data of every group and insert new row at top every group and paste the data copied in to the new inserted row for every group found then change the row color to red as my vba code knowledge not great

    here what i have
    Please Login or Register  to view this content.
    thanks in advance
    please advise me if any more info required

    shane
    Last edited by sspreyer; 12-10-2014 at 04:16 AM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: insert a row to every group and change color of every top row of group

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: insert a row to every group and change color of every top row of group

    hi , Sixthsense
    thanks for the tip here's my striped workbook for all to view

    Testfile.xlsm

    thanks in advance
    cheers

    shane

  4. #4
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: insert a row to every group and change color of every top row of group

    hi all

    would it be easier to make the top row of every group red instead of copying the top row and inserting a new row and changing the row red as show in my example work book

    any help much appreciated and is very stuck on this

    shane

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: insert a row to every group and change color of every top row of group

    Quote Originally Posted by sspreyer View Post
    hi , Sixthsensethanks for the tip here's my striped workbook for all to view
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor sspreyer's Avatar
    Join Date
    07-05-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: insert a row to every group and change color of every top row of group

    thanks sixthsence legend!!! you have just save me so much time thank you!!!!!!!
    also i have now made away to reverse it if any one else would like to do the same

    Please Login or Register  to view this content.
    thanks again very apreciated
    shane

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: insert a row to every group and change color of every top row of group

    Quote Originally Posted by sspreyer View Post
    also i have now made away to reverse it if any one else would like to do the same
    Thanks for the feedback

    The below code will work faster than your current code since Find will work faster than looping on each cells

    Please Login or Register  to view this content.

+ 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. Function to change color to group of cells..
    By kenharding in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-15-2014, 12:35 PM
  2. New to add color the blank row being added after group change.
    By Jimmyd48 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2014, 06:16 AM
  3. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  4. Replies: 0
    Last Post: 05-28-2013, 04:52 PM
  5. [SOLVED] Change color of text for a group of shapes
    By emiliekatherine in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 08:43 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