+ Reply to Thread
Results 1 to 3 of 3

Insert blank row after duplicate account number

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    16

    Insert blank row after duplicate account number

    Hi All- I have data that looks like this:

    Acct
    123
    123
    234
    345
    456
    456
    456
    567

    I would like to insert a blank row after each group of accounts so that the data will look like this:

    Acct
    123
    123

    234

    345

    456
    456
    456

    567

    I am relatively new to VBA, but I know there is a way to create this loop. I just haven't been able to find it yet. Any suggestions?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,469

    Re: Insert blank row after duplicate account number

    Try for the start going with your loop down-up like:
    Please Login or Register  to view this content.
    of course for large datasets will be wise to switch off recalculation and screenupdating
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    11-24-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Insert blank row after duplicate account number

    Thanks - that wokred.

+ 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. if Account number = return Account Name
    By mom2carisa in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-04-2013, 06:03 PM
  2. Missing number enter in blank column / row with no duplicate value
    By avk in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-29-2013, 06:53 AM
  3. Return Account Nickname if Account Number Matches
    By spacle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-03-2013, 11:04 AM
  4. [SOLVED] How to censor account numbers based on how many characters are in the account number
    By Mcorydon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-25-2013, 01:06 PM
  5. If cell is not blank, insert number
    By NathanLedet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-18-2008, 04:36 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