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
... .... ...
