Results 1 to 4 of 4

Insert x number of blank rows based on values

Threaded View

  1. 02-08-2024, 05:31 PM #1
    coach.32
    coach.32 is offline
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    Insert x number of blank rows based on values

    In the attached workbook I have a list of values in columns B-F, I have counted the number of values in each row and that total is in Column A.
    How can I insert the number of blank rows between each value based on the total in column A?
    The actual list I have is of course much longer than the sample.
    The desired outcome I have placed below these figures and shaded grey.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert blank rows above a table based on unique values in one of the columns in the table
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2019, 01:06 PM
  2. Insert blank rows above a table based on unique values in one of the columns in the table
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2019, 07:52 PM
  3. VBA Macro to insert number of rows on a different worksheet based on varying values
    By artemis88 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-20-2013, 05:18 PM
  4. [SOLVED] Insert number of rows with data to new sheets based on values in cells
    By keithtran12 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2013, 11:57 AM
  5. [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
  6. insert blank rows based on columns a values numerically
    By elkhole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2009, 04:57 AM
  7. Insert number of rows based on cell values?
    By HBF in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2009, 10:28 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1