Copy and Past Specific Cells From A Row Then On To Next One

[bloodmilksky]

Hi Guys I hope you are all well.

I was just wondering if anyone could help me.

I receive a report and I am trying to automate the emailing of this information out ( which I think I have managed to do) but I am unsure about how to automate the Copy and Paste Side of it.

Would anyone know how to use vba to Copy - past cells from each row until there was no data left. so as an example.

Sheet 1 Row 2 E2 Sheet 2 Cell B7
Sheet 1 Row 2 C2 Sheet 2 Cell B21
Sheet 1 Row 2 L2 Sheet 2 Cell C21
Sheet 1 Row 2 P2 Sheet 2 Cell D21
Sheet 1 Row 2 Q2 Sheet 2 Cell E21

And so on through each row but using the same columns

Many thanks

Jamie

 

[My Aswer Is This]

edit

 

[bloodmilksky]

my appologies it would be
E2
C2
L2
P2
Q2

E3
C3
L3
P3
Q3

E4
C4
L4
P4
Q4

and keep going until the data ran out