+ Reply to Thread
Results 1 to 3 of 3

Insert row below each selection

  1. #1
    Registered User
    Join Date
    08-20-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Insert row below each selection

    I need help inserting a row below everytime i select from a dropbox.

    i.e whenever i make a selection from the dropbox, another row will be inserted below it.
    however a row should not be added if a selection is already made on that row.

    so when i pick a selection from cell 3B, a whole row will be inserted below 3B.
    but when i make a selection from cell 3C, since there's already a value in 3B, a new cell would not be inserted.
    the row should still be within the 2A merged cells.


    pardon if my description is too vague. i'm an excel noob. i've attached a picture and the excel file hope it helps. =X


    Many thanks!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-20-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Insert row below each selection

    I've kinda found a solution, but it needs fine tuning.

    ActiveCell.Offset(1).EntireRow.Insert

    However when i make a selection at the next column, a row will be inserted as well.
    e.g 5 selections from dropbox in 5 different columns, will insert 5 rows.

    is there a way to limit it to only one row inserted per 'active row'?

  3. #3
    Registered User
    Join Date
    08-20-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Insert row below each selection

    I was thinking if we can do a, if adjacent cell value > 0 , delete row.

    i came out with

    =IF(B4:B6722>0, ActiveCell.Offset (1).EntireRow.Delete)

    but couldn't get it working. HELP?

+ Reply to Thread

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