Copy data and paste using vba

Closed
a_r_i_e_s Posts 1 Registration date Thursday September 17, 2015 Status Member Last seen September 17, 2015 - Sep 17, 2015 at 06:28 AM
Hi, I've two files, I would like to copy the data and not able to do so.

Source file:

Multiple rows (some times has 60 rows sometimes 80 with few blank lines) data may not be all columns but would like to copy all rows till column AO.


Destination:
data needs to be pasted one by one set of rows from source.

I can share the both files if required.