+ Reply to Thread
Results 1 to 6 of 6

Request Help; Inserting rows after each new name

  1. 11-09-2022, 02:07 PM #1
    #REF!
    #REF! is offline
    Registered User
    Join Date
    11-09-2022
    Location
    NY
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    3

    Request Help; Inserting rows after each new name

    All,
    I need help building a macro or formula to insert two new blank rows after every new name. In some cases names will be listed more than once. Ex: below?
    Thanks!

    Capture excel.PNG
    Reply With QuoteRegister To Reply
  2. 11-09-2022, 02:46 PM #2
    #REF!
    #REF! is offline
    Registered User
    Join Date
    11-09-2022
    Location
    NY
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    3

    Re: Request Help; Inserting rows after each new name

    So this would be the end goal... I toyed around and the furthest I got was:
    In cell I4 -> =A3=A4 -> Which gives "TRUE" as an answer; then pulling it down to the whole spreadsheet column of names. -> Then searching for "FALSE" -> selecting all and inserting sheet rows.
    This will only enter ONE blank row after each name. Wondering if there's a better way...
    Attachment 804366
    Reply With QuoteRegister To Reply
  3. 11-09-2022, 02:56 PM #3
    #REF!
    #REF! is offline
    Registered User
    Join Date
    11-09-2022
    Location
    NY
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    3

    Re: Request Help; Inserting rows after each new name

    attached spreadsheet...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-09-2022, 03:51 PM #4
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Request Help; Inserting rows after each new name

    One way:

    Please try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    If you remove the space after Andrew in row 5 you can also remove 3 times TRIM from the formula.
    Attached Files Attached Files
    Last edited by HansDouwe; 11-09-2022 at 03:57 PM.
    Reply With QuoteRegister To Reply
  5. 11-09-2022, 04:39 PM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Request Help; Inserting rows after each new name

    vba
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 11-10-2022, 02:30 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: Request Help; Inserting rows after each new name

    You have a trailing space in row 5 ... Andrew

    Please Login or Register  to view this content.
    Last edited by sintek; 11-10-2022 at 02:46 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find if a request was opened twice or more using duplicates and request date
    By wellous in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-22-2020, 05:28 AM
  2. [Request for Macro] Merge Similar Rows to 1 Row
    By flaire14 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-19-2017, 12:46 AM
  3. [SOLVED] Code amendment request to hide all rows at the end
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2015, 09:32 PM
  4. Inserting data from one sheet to another without copy pasting an inserting extra rows
    By SeasonedRookie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-20-2014, 11:58 AM
  5. unable to retain HTML when inserting placeholders into Outlook Meeting Request template
    By m0meehan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2014, 03:05 PM
  6. Request for VBA code to compare loumns to rows
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2013, 12:51 AM
  7. VBA Request - List in single cel to individual rows
    By ElizabethDawn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2008, 05:12 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1