Results 1 to 4 of 4

Insert entire BLANK ROW between new TEXT

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2023
    Location
    Philippines
    MS-Off Ver
    18.2303.1201.0
    Posts
    11

    Exclamation Insert entire BLANK ROW between new TEXT

    Hi,

    I have a data whereas its sorted Alphabetically and by time but I need to insert a BLANK row every after a new name.

    I used a formula first where it will return FALSE once its a new name. So I want to insert an entire BLANK ROW above that FALSE result.

    Attached here is the sampla data.

    Will very much appreciate all the response. Thanks
    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. Check if entire row meets specific text, then insert photo
    By Hesham121 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-08-2022, 07:33 AM
  2. Replies: 1
    Last Post: 06-25-2019, 09:31 PM
  3. [SOLVED] Macro to insert blank rows below the text in Col D and copy the text in the new row
    By rehana402003 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2018, 02:25 PM
  4. [SOLVED] Insert Row under cell containing text on entire active sheet
    By mgeddes in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-04-2013, 07:04 AM
  5. [SOLVED] VBA codes to insert the rows and copy the first entire row text and insert sheet
    By PRADEEPB270 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2013, 05:05 AM
  6. Search Entire Workbook for Certain Text, and blank out cells
    By changedsoul in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-28-2012, 08:55 PM
  7. Insert Text When Blank
    By Chuck N in forum Excel General
    Replies: 7
    Last Post: 01-04-2006, 08:40 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