Manage large data. Extract values only on specified dates

Dear all,

I have a large data of events that happened trough time, with hundreds of line values. I attach here a little sample of the data that I have:

Please Login or Register  to view this content.

As you can see this is a hourly time-step data.

I would like to have a VBA code that could extract certain spaces in time and the correspondent data from Station rows ("B", "C" and "D"). For example, I want a code that could search on the "A" row for all the data in the Winters. The code should then search only for dates from 21-12-2002 to 20-03-2003, then 21-12-2003 to 21-12-2004.... and so on until the end of my "A" row.

After that search it should copy and paste all the data that is allocated to that date (data from Station 1, Station 2, Station 3) in another worksheet.

Can someone give me a help over here?

Thank you

Originally Posted by millz

Sounds like you can achieve what you need with the filters?

Dear millz, thank you for your reply.

I already looked under the filters options, but I'm only able to restrict the data to quarters. I really can't (or I do not know how) restrict to certain specific datas like from 21-12 (all years) to 21-03 (all years also).

Do you know if that's possible to sort out using filters?

Regards

Originally Posted by millz

Is your date column formatted as date? I just copy-pasted your small sample data in a blank sheet and I am able to filter by year, month, and day.

Yes it is. But are you able to filter automatically all data from 21-december to 20-March from all years? Or you have to write the years one by one? for example:

21-12-2000 to 20-03-2001, 21-12-2001 to 20-03-2002... and so on.

Can you do this on the filter just to select 21-12-xx to 20-03-xx?

Originally Posted by millz

I see, so you want the same date range over all years. If this is a one-time process, maybe you can just Date filter -> and use Between..., and repeat for each year?

Exactly! I want the same range over all years! The problem is that it is not a one-time process.. I have this kind of data for different station locations so I have like 30 Excel files with this kind of data, and some of these Excel files have data from 1950 to 2016.. Thats a lot of Winters... :\

Regards

Dear millz,

OUTSTANDING!! Thank you so so so so much for the code! I understand it and I can adjust it to my needs!

Can't thank you enought! I will give you reputation and off course set this thread to solved!

Regards!