Results 1 to 8 of 8

Insert rows based on value in cell.

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Insert rows based on value in cell.

    New to programming for excel. Want to run a script to add rows beneath each row based on the value in one of the cells in that row and then move to the next row of data and do the same.

    For example:
    Cell E5 = 7, I want to Insert 7 rows beneath row 5, then move to the next row and insert the number of cells equal to the value in column E of that row.

    Not sure how/where to enter the script either. I'm fine with in-cell formulas, and using the record-macro tool, but have little experience writing and running scripts in excel so as detailed as possible would be greatly appreciated.

    Thanks so much
    Last edited by JPEckelman; 05-16-2011 at 04:18 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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