I'm trying to find VBA code to be able to set the value in column U to "TRUE" when the Date in column A is the "most recent" based on a value in column B.
So what I have is a list of numbers in column B and a date in column A against each number. The numbers in column B may be repeated once or several times, but with different dates in column A against each instance of that number. I need the code to find the most recent entry for each number based on the date in column A and then set the value in column U to "TRUE" for that entry. It then needs to process the next number in column B in the same way, until it reaches the end of the record set.
It would be greatly appreciated if somebody could help me with this.
So what I have is a list of numbers in column B and a date in column A against each number. The numbers in column B may be repeated once or several times, but with different dates in column A against each instance of that number. I need the code to find the most recent entry for each number based on the date in column A and then set the value in column U to "TRUE" for that entry. It then needs to process the next number in column B in the same way, until it reaches the end of the record set.
It would be greatly appreciated if somebody could help me with this.