VBA Copies but Paste data in another columns(not in required)

Below VBA copies data from file Report.xlsx and paste in workbook Dash at sheet "RawDataBher". I want to paste the data at column A to E but it paste at Column A & B and leave Columns C & D blank and other data is pasted at column e,f,g as shown in attached picture. Please Help
Attached are the workbooks

Please Login or Register  to view this content.

The "C:D" columns are empty because in your "Report.xlsx" file, they are merged columns - you have to reorganize the data layout, without merged cells in the columns ("B:D").

Can you please help me, how can i clean the data please?

See here:

https://support.office.com/en-us/art...f-c673a93fcedf

, but before you do that, look carefully at the range of cells "A3662:G3733" and organize the data here - the data layout is "very broken".

Okay Thankyou..let me see.

Please Login or Register  to view this content.

@jindon Thank you it,s copying but with a little mess, as shown in attached picture. By searching 080019000212, at this position data is not in good shape as suggested by porucha vevrku.Now as i have converted this from PDF to excel, it is going to be difficult to handle it i think, therefore i converted it to word document, can we now fetch the data from this docx file to excel please, attached is word file too

No, it has started more problems as shown in attached pictures...In some areas it is skipping Grade data and some areas it is pasting..

How do you want it then?

Originally Posted by jindon

Try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Or F5...

Have you tried F5, instead of F6?

Yes i tried but then it skips alot of data. With due respect, there are two options:
1) we need to clean the data as shown in attached two pictures, data needs to be organized but it will be difficult
2) i have tried below code which copies data from word document to excel, it works but with some mess, i m posting the code along with pictures in next comment please

Exactly but i thought you may look into the code along with the word file, if it needs some modification, so you can do it, if possible. It,s upto you..no worries..You are such a nice person and i respect for your kind time and help. otherwise, i may wait for someone else help but i know you have extra capabilities. well thank you jindon for help.