Hi XLD,
Your code is working really well thank you again.
If you have the time and are happy to continue with my post, the second part which is 'where trades have not matched off I show the open position in column Y' would be great to get my project completed.

Thank you.