+ Reply to Thread
Results 1 to 1 of 1

Macro to insert rows and columns using a value from the drop down list

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    1

    Macro to insert rows and columns using a value from the drop down list

    Hello all,
    I am new creating macros in excel and would like to explain what I want to achieve.
    I Have an initial table with empty cells and formulas inside the range A5:Z20
    And I would like to insert 2 options:
    1) "Insert a number of additional rows bellow" in cell M3 (this cell is a drop down list with options: "Add 10 rows", "Add 20 rows"or "Add 30 rows")
    If the user selects "Add 10 rows" then the row 20 is copied and insert 10 rows bellow and paste them with formulas, and the same thing for the other options.
    2) "Insert a number of additional columns" in cell M1 (this cell is a drop down list with options: 1,2,3,4,5,...60)
    The default option in the cell must be "1" and the column AA and AB are already charged. (Header for AA: "Quantity", header for AB: "Extended cost")
    If the user selects "2" then 1 more column is added between AA and AB, copying and pasting column AA (copy Header and empty cells) at the same time
    1 more column is added to the the right of AB copying and pasting column AB (copy Header and formulas)
    The idea is to insert columns to the right, if the user selects "60" then 59 columns are going to be inserted apart to 1 fixed cell.
    a) Column AA is fixed cell (with a header and empty cells) and more columns can be inserted until column CH at the same time
    b) Column AB is fixed cell (with a header and formulas) that changes position depending of the columns inserted to the left and more columns can be inserted until column is variable column.
    See the attachment with the spreadsheet
    Thanks for your support.
    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)

Similar Threads

  1. Calling multiple columns/rows from drop down list
    By hwtcrl in forum Excel General
    Replies: 3
    Last Post: 02-05-2013, 09:45 AM
  2. [SOLVED] Macro the hides entire rows based on a drop down list
    By MGK086 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 11:32 AM
  3. [SOLVED] Macro Filter to hide rows based on Drop Down List
    By dieseldogpi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2012, 11:19 AM
  4. Need Macro to insert a Specific number of Rows (in Filtered list)
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2012, 08:05 PM
  5. [SOLVED] Excel Macro to insert rows in a list
    By MartyCole in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2005, 03:06 PM

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