Originally Posted by
georgiboy
Out of pure interest, was the above not a suitable option?
I'm sorry, I had attempted to post a reply and just realized that it never actually posted. What you provided is amazing and does exactly what I was originally thinking. The only issue I ran into was using it with my existing code.
The code that I have sorts the rows based on the values in columns C and A. The issue now is, when I update the date in C6 it will kick that row down to C14, but if I hit the undo button it puts the old values back into what is now in C6 even though that wasn't the original row/cell that was changed. If that makes sense.
This is the code that I have to sort the sheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A5").CurrentRegion.Offset(1).Sort [C5], xlAscending, [A5], , xlDescending
End Sub
Reply With Quote