+ Reply to Thread
Results 1 to 4 of 4

loop through rows for match insert blank rows with title

  1. #1
    Registered User
    Join Date
    07-14-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    11

    loop through rows for match insert blank rows with title

    hi all,

    whats the easiest/best way to achieve the following

    -loop through all rows starting from a specific row i.e. 5 up until row X (the count of rows with data, ive already got the count bit)
    -searching for a match in column 9 (I)
    -once found insert 2 empty rows above it
    -goto column A of the lowest empty row and insert a title
    -then end
    -if no match was found then do nothing

    thanks in advance

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,978

    Re: loop through rows for match insert blank rows with title

    You would have to use a macro to do that, as a function/formula can't be used to insert a row.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-14-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: loop through rows for match insert blank rows with title

    oops yes i know, ive added this thread to the wrong section by accident! thanks for making me aware

    could a moderator please move this to the vba section please? silly me

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: loop through rows for match insert blank rows with title

    could a moderator please move this to the vba section please?
    And so it shall be.

+ Reply to Thread

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