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.