Macro to copy and paste repetitively [Closed]

Report
-
 hl -
Hello,

I would like to develop a macro which can copy a cell value and paste the exact value in the three rows below. Then, repeat the motion automatically for the rest of the column.

i.e. The data table shows the number of shirts purchased by each customer. The macro that I am looking for will copy each name and paste it for each of the three rows below and repeat that operation for the entire column A. FYI, the actual spreadsheet has 600 rows.

A B C
1 Name Color Num. of purchases
2 Jack Red 2
3 Blue 4
4 White 6
5 Dark 8
6 Jerry Red 3
7 Blue 4
8 White 6
9 Dark 8
... .... ...


Final results
A B C
1 Name Color Num. of purchases
2 Jack Red 2
3 Jack Blue 4
4 Jack White 6
5 Jack Dark 8
6 Jerry Red 3
7 Jerry Blue 4
8 Jerry White 6
9 Jerry Dark 8
... .... ...

Any help would be very much appreciated.

1 reply

i need the code for for comparing two values in excel and copy the data from one excel sheet to other using vb script

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!