improving speed and efficiency

I need help in trying to improve the speed of my code I have included the code below in the attached test file with some dummy data to show what I’m trying to. as it seemed to long to post all the code.

Any useful suggestions would be greatly appreciated.

Regards
John