+ Reply to Thread
Results 1 to 2 of 2

Insert 3 blank rows after every 6 rows of existing data

  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    Travelers Rest, SC
    MS-Off Ver
    Excel 2010
    Posts
    48

    Insert 3 blank rows after every 6 rows of existing data

    I'm trying to bulk update inventory by adding blank rows after each of the existing items. Each item has a set of variants so "Item 1" is listed 6 times in a row, once for each variant. I've attached a sheet showing "Current" results and "Desired". Is this possible without code? If not, I'll try the code...

    Very grateful, thank you.

    Joe
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,009

    Re: Insert 3 blank rows after every 6 rows of existing data

    .
    Paste this code into a routine module, call from a Command Button on your worksheet :

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Replies: 11
    Last Post: 07-30-2015, 12:35 PM
  2. [SOLVED] insert blank rows every nth row and copy down data to fill blank rows
    By surpass in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2014, 02:55 PM
  3. Replies: 4
    Last Post: 09-16-2014, 10:48 AM
  4. [SOLVED] Insert Blank Rows between existing data based on dups in sheet2
    By Melissa Camp in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-29-2014, 07:07 AM
  5. How to create a macro to insert blank rows and copy data into blank rows?
    By zodiack101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 01:18 PM
  6. [SOLVED] Macro to insert blank rows so that the total number of rows with data is equal to 1021
    By nsm1411 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 10:25 AM
  7. Replies: 3
    Last Post: 08-16-2012, 01:31 AM

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