Copying data depending on chosen date to another worksheet

[Bishonen]

Hello all,

thanks for taking your time!

Straight to the problem:

I have a file with multiple sheets. Each sheet contains data for the next ~15 weeks on a 30min interval basis.
Every day I'm being told which 4 weeks need to be copied to another file. Sometimes it's the first 4; sometimes the last ones (everything in between is possible as well).

I'm thinking about a vba code to help me out with this tedious work (it takes about 5 min -not thaaat much. But it sums up over the time).

What i was thinking about: chosing one week from collumn "K" with a userform (i can type it in as well). The macro would then look up the appropriate week in collumn "B" + the 3 following and copy it to "sheet2" (I'll change that part in the macro to another workbook). I need only the values - don't need collumn "A", nor the date or weekday.

The same has to be done for every other worksheet in the given file (in this case I've included only 2 - but there will be more).

If anyone can think of some code for that, I'd more than appreciate it!

Thanks again!

Copying data.xlsx

[rvasquez]

Hello there,

Will the times in between the dates always be 0:00 to 23:30?

Thanks!