I have a problem similar to one already discused about filling data into cells, but couldn't make heads or tails of it.. I'm quite new at VB and programming generally.
I have a matrix of data in excel that's something like this:
103 2 3 34 20 SGH .5
103 2 3 34 GA .5
103 2 3 34 TO 3.5 2.4
103 2 3 34 9 GA .5
with many more records,
the first record has "20" in the 5th column. I want to make 19 more duplicates of that row and add it to the matrix. other records may have no values or like the last one, 9 (so I'd want to add 8 more records)
how do I go about doing this?
thank you!
I have a matrix of data in excel that's something like this:
103 2 3 34 20 SGH .5
103 2 3 34 GA .5
103 2 3 34 TO 3.5 2.4
103 2 3 34 9 GA .5
with many more records,
the first record has "20" in the 5th column. I want to make 19 more duplicates of that row and add it to the matrix. other records may have no values or like the last one, 9 (so I'd want to add 8 more records)
how do I go about doing this?
thank you!