I had a look on replies but didn't see what I was looking for.

What I am trying to do is perform a sort based on

a. The user selecting the range
b. The sort being performed on the first few characters of a string (a date value - in
MM/DD/YY format)

If possible I want to automate this as a right click option but am not sure if this
will work? Although getting a sort routine working would help and I could try to figure out myself if I can right click to operate it.

Thanks in advance


The data has (3 columns the middle one being the string containing the text and date value)