I have written the following code to track any changes in range("C4:D" & lr)
I don't need to use ranges as helper to do this. Could it be stored in an array then to sort the new entered data and at last to put the new array results to the range
Please Login or Register to view this content.
Hope the code is clear
Put any data in sheet1 in C4:D8 for example