Hello ,
Is there a way to jump to the duplicate value in column M. I want Vba to jump to the first instance of the duplicate value so that If the word "Thomas" is at M5 and at M20, I'd like to be taken to the top value which is M5. By taken I mean to scroll to the cell's row. Please also note that the column M will only have one duplicate entry and more than one duplicate entry is not possible. Also kindly note that I want to scroll Row only and not the column.
Will appreciate and much thanks.
Is there a way to jump to the duplicate value in column M. I want Vba to jump to the first instance of the duplicate value so that If the word "Thomas" is at M5 and at M20, I'd like to be taken to the top value which is M5. By taken I mean to scroll to the cell's row. Please also note that the column M will only have one duplicate entry and more than one duplicate entry is not possible. Also kindly note that I want to scroll Row only and not the column.
Will appreciate and much thanks.