Incorporate Loop Function In Recorded Macro

In the CSV file attached "DOR REPORT.csv" the data should only be in the columns A to M and O, it shouldn't appear in any columns (everything in columns A to F is all correct).

What the code does is :

- CTRL + DOWN ARROW (reaches a row that is displaying data in the wrong columns as nothing should appear in the N column)
- CTRL + SHIFT + LEFT ARROW
- CTRL + F and search for "CONT_ADV" in that row (which is why the previous step was done to find CONT_ADV for that row)
- Press ESCAPE to close the "Find and Replace" prompt
- Click the LEFT ARROW (twice)
- CTRL + SHIFT + RIGHT ARROW (twice) which in this spreadsheet it would highlight the data as per image below:

Data Selected.png

- Cut that data, go to column G in the same row and paste it

I want to be able to activate the macro once so all the data on the spreadsheet is in the correct columns instead of pressing it x amount of times to go through the whole workbook.

The code doesn't have to stick to this, this is purely what I have recorded.

I hope this is a better and clearer explanation, thank you.

Thank you for responding and hope you had an enjoyable holidays.

Only adjustment I made to your code is:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

With the code above however, I will have to activate it multiple times for all the data to be in the correct columns as there may be more data that may have shifted to the right as per image below:

Capture.JPG

I rushed the last reply, hopefully this should be more clearer:

- The data in RED needs to shift to the left according to what I have written in column T, over the ORANGE data;
- GREEN is correct data and doesn't require to be shifted. So as you see in row 11 of the image, the data is where it should exactly be;

The misaligned data could appear anywhere in a CSV spreadsheet that may contain over 5000 rows of data which an example of the workbook be in the opening post "DOR_180914.csv‎", the data could also shift more to the right in comparison to the image.

End result should look like the image below:

Capture2.JPG