Find a Max Date based on a corresponding value VBA
Find a Max Date based on a corresponding value VBA
http://www.mrexcel.com/forum/newthread.php?do=newthread&f=10
Hello everyone,
I'm in the process of trying to figure out how to find the max date of a value in column A. From there I need to link up the price associated with that date. VBA is preferred. The information I'm working with is structured like this in this image:
What I want to do using VBA, is to look at the values in column A and for each of them, find the max date or most recent date. Once that is determined, on a new sheet, I want to write the value found in column A in sheet2/ColumnA and the date in column B, and the price in column C. In a nutshell, I'm looking for an effective date for pricing. The example on the bottom is basically what I'd like to extract with code onto another sheet.
I've tried doing it with a pivot table with no success, and I tried a little bit with the scripting.dictionary, but that's kind of confusing to me. If anyone could help with this, it would be much appreciated.
Note to add is that this data is dynamic and is updated daily. However the structure is constant.
thanks,
jimalya
Find a Max Date based on a corresponding value VBA
http://www.mrexcel.com/forum/newthread.php?do=newthread&f=10
Hello everyone,
I'm in the process of trying to figure out how to find the max date of a value in column A. From there I need to link up the price associated with that date. VBA is preferred. The information I'm working with is structured like this in this image:
What I want to do using VBA, is to look at the values in column A and for each of them, find the max date or most recent date. Once that is determined, on a new sheet, I want to write the value found in column A in sheet2/ColumnA and the date in column B, and the price in column C. In a nutshell, I'm looking for an effective date for pricing. The example on the bottom is basically what I'd like to extract with code onto another sheet.
I've tried doing it with a pivot table with no success, and I tried a little bit with the scripting.dictionary, but that's kind of confusing to me. If anyone could help with this, it would be much appreciated.
Note to add is that this data is dynamic and is updated daily. However the structure is constant.
thanks,
jimalya