Excel VBA

Hi Gary,
Based on our prior conversation on the forum, I have created a macro to handle the raw data saved on the “RawDataBackUp” page of the attached excel file to the mail I sent you today. However, my macro has some issues which I hope if you could help. Please see my questions listed below:

The macro runs very slow. It sorts the data one row at a time. Is there anyway can make it run faster?

In order to remove the specific rows I inserted an extra column with “x”at Column A first. Is there any other way that I don’t need the extra column while it can do the same work?

I want to remove the last three rows of the raw data, every time i run the macro. I created a Dim function which seems not working in the macro, but if I test it separately it works well. Could you please have a look and see why.

How can I rename the field titles as listed below? The field title in the raw data is actually split into two rows. You see if I run the macro the top part will be removed and then there will be two columns with same field title. Don’t know if it matters but is there any way I can replace the old title to the new title as listed below?

I planned to make the macro do in the order as listed below:
1.Remove the top 10 rows
2.Remove column M “Remarks”
3.Remove any row that start with blank cells or “__” or “Cy” or, has blank cells in column D
4.Rename fields name as per my email
5.Adjust the column with

On the spreadsheet I have put the original RawData on the “RawDataBackUp” page. And you can test my Macro on the “TestSheet” page where has the same data.
Please let me know.
Many thanks
Walt