+ Reply to Thread
Results 1 to 3 of 3

Insert new rows below once the button to add new row is clicked

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    5

    Insert new rows below once the button to add new row is clicked

    Hi All,

    I am fairly new to VBA and Excel macros and I have to prepare a macro wherein I am required to insert a row one after the other and a drop down list options present in the row above should be copied in the inserted row

    the scenario is as follows
    1. Range(c5:E5) has dropdowns where in C5 has geographies (drop down) and D5 : E5 is merged with locations / addresses
    2. If a user wants to add more locations, they can press a button and a row shall be inserted below (C6:E6) with the list options present in D5:E5 pasted in the inserted row.
    3. This macro should run for as many locations as the user wants to add

    Other considerations
    1. There is more data below in the sheet, hence D5:E5 is not the last row

    Will appreciate any help on this

  2. #2
    Forum Contributor visha_1984's Avatar
    Join Date
    11-27-2012
    Location
    Pune,India
    MS-Off Ver
    Excel 2010
    Posts
    290

    Re: Insert new rows below once the button to add new row is clicked

    dearsurabhi

    post sample file.
    Happy to Help

    VISHA

    Click *, if the suggestion helps you!
    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"

  3. #3
    Registered User
    Join Date
    02-21-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Insert new rows below once the button to add new row is clicked

    here it is... I was playing around with the VB code initially hence you might get some codes in there already

    Thanks for helping out
    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)

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