New to vba and looking for a quite specific solution to a work project. Wondering if it's possible to import a weather METAR from wunderground.com to the selected cell based on the date/time in the same row? I've included my workbook, which includes a sample macro for pulling data from wundergound. Basically, I'd like the macro to look at the year in "B", month in "C", day in "D" and zulu time in "O" and give me the full METAR in "U" that is closest to the time in "O". The station will always be "KTVC". wunderground will export all of the weather METARs for a day in a csv, which I've managed to do separately, but because of my limited vba knowledge, am stuck there.
I also have a separate macro, modified from a version found on this site for my use, to parse the imported METAR into "V:AG". Next question would be, is it possible to do both actions in one macro? That is selected and row in "U" and have it pull the data and parse?