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.
Bookmarks