+ Reply to Thread
Results 1 to 2 of 2

VBA to insert 85 empty rows based on specific recurring cell value in a column

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    Germany
    MS-Off Ver
    MS Office 2010
    Posts
    34

    VBA to insert 85 empty rows based on specific recurring cell value in a column

    Dear all,
    As I am beginner in VBA, I am seeking in this forum for a VBA code to do the following (I have seen plenty of similar questions but not solving my wish unless I overlooked it).
    I want to insert 85 empty rows in the attached example of excel, based on column B, whenever the value 14 is shown.
    Empty rows should be inserted after the rows with value 14 in column B.
    (Or if before, then before the value 15 appears each time)

    I thank all who can help me.

    Best regards
    Heinz
    Attached Files Attached Files
    Last edited by megaheinz; 04-17-2024 at 03:24 PM.

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: VBA to insert 85 empty rows based on specific recurring cell value in a column

    This macro assumes that your data in column B starts in row 11 as in your sample..
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

+ 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. [SOLVED] insert empty rows after a cell containing specific texts.
    By barrowinfurnace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2019, 03:57 PM
  2. [SOLVED] how to insert empty rows based on column B cell values and paste above values with macro?
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2018, 11:47 AM
  3. [SOLVED] Deleting worksheet rows based on if the first column cell is empty
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-04-2017, 07:58 PM
  4. [SOLVED] How do you insert cell contents from one column into another based on a specific part?
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-30-2014, 08:55 AM
  5. How to delete rows based on whether or not a cell in column B is empty or null
    By Seth_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2014, 04:35 PM
  6. Delete Rows Based On Empty Cell in Column Works Perfectly For A, but Not J
    By votekinky06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-27-2014, 05:41 PM
  7. Need Help w/Macro That Will Insert Column Based on Specific Text in a Given Cell
    By pb6933944 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2012, 12:23 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