Hi, deepsi1,

add the cells to copy and paste in the Arrays:
varArr1 = Array("B2", "B4", "B7", "C7", "F7", "G7")
varArr2 = Array("B2", "B4", "B8", "C8", "F8", "G8")
The copying will be done by the length of the Arrays but the cells would need to be directly side by side (no other data in the columns from A to F). If you want other values in there you would need another array holding the columns from which to take and in which order.

Ciao,
Holger