Excel macro to copy rows in one sheet and insert into another sheet
I need a excel macro to copy some rows in worksheet 1 to insert into 3rd row of worksheet 2. The number of rows to be copied depends on the value present in column A3 of worksheet 1
eg .
AAA 123 2
BBB 456
DDD 789
here 2 in 1st row decides the number of rows to be copied
Please help me in this issue.
Thanks
Vasanth
|