Hi XLD,
Thank you for getting back.
I have just sorted by Columns B,I & G (Client Code, Stock Description and B/S) Descending,Descending & Ascending).
All seems to be working on the samples that I have attached, but still testing.Test 2.xlsm