Macro code to Copy specific rows into specific columns

Hi

I am not a programming person...really struggling to write a macro. I am good for recording macros but not in programming. But I would really really appreciate if anyone can help me in solving my problem.

I am trying to copy Extract-batch 13(sheet1 which is dp here) all the rows until a blank row comes to ShareWB (Sheet1, called DP again) from J column though to M in the sequence but I want this to be pasted exactly after the data column(In this case this is J14 to M14). For coding purpose if macro understand 'blank' column. I can say to paste it in the same sequence J to M where it encounter a blank (For J column in this case). After this I have to apply some formulas...but that I can manage. I just need the code for copy and paste..its not very simple I guess.

This is a reconcilation tool. So I will be collating the data after each extract in the same sheet. And I have this to do for all the 4 sheets DP,RP,DC and RC.

PFA the worksheets. (Extract-batch 13 and ShareWB).

Thanks for looking and helping.
Su.

Hi Arlette,

Thanks for your reply.

No other conditions really.

I just want to copy all the data from extract (Here in the sample file rows 2 to 10) to be copied to where it finds the blank row, here it's 14th row and Column J through to M in the same sequence as it is).

The extract normally have more 1000 records and multiple sheets.

Thanks,
Su.

Destonation file would be opened at that time, yes.

I need the macro in destination file...so I will run and macro and that should do the purpose.

Thank you very much Arlette...I really appreciate. Thanks again...:-)

Su.