Macro to duplicate row based on cell value

R

rscartoni

Joined
Jul 22, 2014
Messages
1
Reaction score
0
Hi Guys,

I have tried to re-search previously threads on this but could not find an answer.

So I have an list of 474 groups which I need to copy each of the 3times. so result should be the value on column plus 3x it.

I.E.
Column A
01-01-01
01-02-01
01-02-02
01-02-03

Result should be:
01-01-01
01-01-01
01-01-01
01-01-01
01-02-01
01-02-01
01-02-01
01-02-01
01-02-02
01-02-02
01-02-02
01-02-02
01-02-03
01-02-03
01-02-03
01-02-03


Really appreciate any support.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup part of a cell's contents and return value of entire cell 2
macro to add numbers based on set criteria 6
Supressing a #VALUE! error returned? 3
lookup first & last values within row & return column header value 12
Sum value between two dates and copy to new cell 6
Identify occurences that occur after a date but not before 1
Macro to put info into certain columns based on info in another co 1
How to avoid Duplicate values .. but want the first value to added in group totals 0

Top