Hi
I am a total beginner and i am trying to write a macro to do some operations on a dataset, but I cannot get through it. can someone help me? thanx!
The start matrix
A B C
row1 abc def 3
row2 ghi lmn 2
the matrix must be copied on a different sheet than i need to replicate each row as many times as indicated in column c + fill in an extra cell (column D) that concatenates the content of cell B and C
in practice, the result to be obtained
A B C D
row1 abc def 3 def1
row2 abc def 3 def2
row3 abc def 3 def3
row4 ghi lmn 2 lmn1
row5 ghi lmn 2 lmn2
i will really appreciate any help! thanx a million!
Bookmarks