Sorting hourly data

[killakella]

Hello,

I have a year's worth of hourly weather data that I would like to extract certain dates/hours from. In the attached worksheet column A contains the specific 1,039 hours I would like to filter from the complete 2010 raw data set starting with column L. It's a lot of data and I am going to have to do this more than once, so I certainly don't want to do this manually. I am lost as to how to set up functions or a macro to do this automatically. Can anyone help?

Thanks!
Ryan

[yay_excel]

Hello,

I did this using a macro. You can see it if you press Alt+F11 and look in Module1.

Your data is in the second sheet (Sheet1). There are blank lines where the complete list did not include the date you sought.

Let me know if that's not what you needed.

K

[killakella]

Hello,

I did this using a macro. You can see it if you press Alt+F11 and look in Module1.

Your data is in the second sheet (Sheet1). There are blank lines where the complete list did not include the date you sought.

Let me know if that's not what you needed.

K

That worked great, thank you! How would you modify it so that it fills in the blanks (missing data) with the last available data point?

[yay_excel]

Replace the code I provided before with this one:

Please Login or Register  to view this content.

Place your cursor at any point in the code and press F5. Depending on how fast your computer is it may take awhile. Let me know if that works.

[killakella]

Replace the code I provided before with this one:

Please Login or Register  to view this content.

Place your cursor at any point in the code and press F5. Depending on how fast your computer is it may take awhile. Let me know if that works.

That worked great too, thanks again!