Danielle22103
New Member
- Joined
- Dec 15, 2005
- Messages
- 13
hi there
I am trying to create a vba worksheet change code to do the following:
Once a cell Sheet1(a1) is populated with a quantity (drop down list 1-10), rows 1-3 on sheet 2 are to be copied and inserted on Sheet1 row 2 repeated by the cell value.
When a cell Sheet1(b1) is populated with a quantity rows 4-6 on sheet 2 are to be copied and inserted at the next row below the previous step. (This is not the last row of the worksheet).
Is this possible?
I am trying to create a vba worksheet change code to do the following:
Once a cell Sheet1(a1) is populated with a quantity (drop down list 1-10), rows 1-3 on sheet 2 are to be copied and inserted on Sheet1 row 2 repeated by the cell value.
When a cell Sheet1(b1) is populated with a quantity rows 4-6 on sheet 2 are to be copied and inserted at the next row below the previous step. (This is not the last row of the worksheet).
Is this possible?
