Modification suggestion(s) to speed up my code

Dear Experts,

I have a long code created with the help various experts here.
This code handles 999,999 rows and 20 columns in one sheet. Entire process takes a long time and now I am trying to improvise various pieces put together and again seeking help here to make it a better code. The part of code shown below takes 43.64 seconds just wanted to check if this is reasonable time for the process!!!!

Looking for any help to improvise as entire code takes about 7 minutes to run.

Please Login or Register  to view this content.

Best Regards/VKS

Thanks a lot for your comments Richard Buttrey.
I thought as much that members would want to see the data but i cant post the original data. I can try to post some sample sheet but do u think its necessary that sample sheet also goes down to 999,999 rows..... also if i post the entire thing then it may appear as a project and most of the members may lose interest thats why tired with first part of the macro.
Best Regards/VKS

Thanks for your comments.... let me start working on a sample sheet that represents real data.
Narrative may take bit longer than sample sheet but i shall try to make it a detailed one.
Thanks for your help
VKS

See Richards answer.

change

Please Login or Register  to view this content.

into

Please Login or Register  to view this content.

Avoid .Select. It looks like the macro was recorded with the macro-recorder. Change the code manually and delete all the .Selects.

Hi, Attached, please find a sample sheet with limited data and explanation of what i am trying to reach with the part of code above.
Hope this makes it bit clear...
Best Regards/VKS

Thanks a lot Norie its gone down to 19 secs