Copy data and paste using vba

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.

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

I can share the both files if required.