Results 1 to 4 of 4

Insert a blank row ABOVE a certain character in a column when the character can repeat

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2010
    Posts
    110

    Insert a blank row ABOVE a certain character in a column when the character can repeat

    Hi,

    I am new, and have looked for a solution, but no luck. If have a column, say G, that has either H or D in it. I want to insert a blank line above any instance of H. I have tried the code that I could find, but if I have H in two consectutive rows, it does not insert the blank row. example below.

    Column G
    Before

    H
    D
    D
    H
    H

    After

    H
    D
    D

    H

    H



    Please let me know what additional info you may need. Thank you inadvance for any help.
    Last edited by theglitch; 11-08-2012 at 04:53 PM.

Thread Information

Users Browsing this Thread

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

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