+ Reply to Thread
Results 1 to 4 of 4

Inserting blank cells based on value in another cell

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    263

    Inserting blank cells based on value in another cell

    I have attached a sample of what I am looking to do. In the Columns A-D I have my data and what I would like is a macro that will insert the number of blank cells (ie 11 and 3 in this case) under the populated cells. The hoped outcome is in columns F-I.
    I have seen many codes that mention Row insert but I'm just wanting to insert a certain number of cells across and down, not an entire row.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Inserting blank cells based on value in another cell

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Inserting blank cells based on value in another cell

    Try this:

    HTML Code: 
    Last edited by ikboy; 03-29-2016 at 12:37 AM.

  4. #4
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Inserting blank cells based on value in another cell

    Both responses worked exactly how I wanted. Thank you to you both. It is wonderful to be able to ask a question and have people so willing to share their expertise.

+ 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. inserting comments to cells based on the values of that cell and one other cell (VBA)
    By michaelhowes25 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2016, 06:16 AM
  2. Inserting blank rows based on condition
    By ananth22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-09-2015, 04:32 PM
  3. [SOLVED] inserting two blank lines when based on data in a column
    By El Conquistador in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-08-2013, 02:05 PM
  4. Inserting a blank Row based on column groups
    By OLBaID in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 04:32 PM
  5. Inserting images into a cell based on another cells value.
    By ccScotty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2012, 12:08 PM
  6. Inserting cells to the left based on cell value
    By Judge Dredd in forum Excel General
    Replies: 5
    Last Post: 03-11-2011, 04:39 AM
  7. VBA: inserting blank cells
    By Flabbergaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2010, 08:09 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