muddakinjaz
08-09-2016, 12:36 AM
Hello, I need to copy each row of data for 8760 rows starting from (B2:J2) and paste it 4 times each onto another sheet. A1:J1 is already filled and so is A1:A8761 on the new sheet. This is an example of what I want the outcome to look like:
Sample
ColA ColB ColC
TextA TextA1 TextA2
TextB TextB1 TextB2
TextC TextC1 TextC2
Results (for example 3 times)
ColA ColB ColC
TextA TextA1 TextA2
TextA TextA1 TextA2
TextA TextA1 TextA2
TextB TextB1 TextB2
TextB TextB1 TextB2
TextB TextB1 TextB2
TextC TextC1 TextC2
TextC TextC1 TextC2
TextC TextC1 TextC2
I have practically 0 knowledge of macros so help would be greatly appreciated. Please and thank you very much!
Sample
ColA ColB ColC
TextA TextA1 TextA2
TextB TextB1 TextB2
TextC TextC1 TextC2
Results (for example 3 times)
ColA ColB ColC
TextA TextA1 TextA2
TextA TextA1 TextA2
TextA TextA1 TextA2
TextB TextB1 TextB2
TextB TextB1 TextB2
TextB TextB1 TextB2
TextC TextC1 TextC2
TextC TextC1 TextC2
TextC TextC1 TextC2
I have practically 0 knowledge of macros so help would be greatly appreciated. Please and thank you very much!