VBA Find Specific Weeks of Data

Ok, Not sure how to even put my problem into writing but I will try.
So I have a sheet of data that gets updated daily. Once a week I have a report that gets filled out from the data contained in the Database Sheet.
The Report is comprised of 7 days worth of data beginning with Monday and ending with Sunday. Each Report is identified by the Week Ending Date. I need to be able to sort through all the data at anytime and generate these reports. I created a Userform which has a ComboBox with the Months listed, Beside that is a TextBox where the year can be entered. Once the Criteria is selected there is a second ComboBox which should have up to 5 options for that month. Each Option would be a Week Ending Report. What I tried was to create a named Range of the data by Month. If I could do that I could search for the First "Sunday" and then use .Offset to go from there. But I am not sure how to narrow down my named Range to be in the correct year and then in the correct Month. Please Help. Thanks!

I'm not familiar with Pivot Tables but I need it to work with vba for the simple reason the actual worksheet looks vastly different then the test sheet i attached. It uses close to 100 columns of data and has many other vba tools built in as well. I'm just looking for a method to then incorporate into my actual sheet. If I select February, 2016 I need my macro to find the first Sunday in the month of February in the Year of 2016 and assign it a variable. From there I am set and know how to proceed.

This for the Button Generate Report
With this code result go to Sheet Report if it is present in the workbook

Please Login or Register  to view this content.

Kind regards
Leo

Thanks for the replies so far, LeoTaxi I tried your code but it does not seem to be working, it copies 7 lines of data to the report Sheet but it is not the correct lines of data. When my userform has February, 2016 selected it copies this data to the Report Sheet. See Screenshot http://prntscr.com/d56ifo

Strange, this is the result i get

the file were i get good result




Kind regards
Leo

result is February

Comobox2 emty from 1 to 7
Combobox2 with 1 from 8 to 14
Combobox2 with 2 from 15 to 21
Combobox2 with 3 from 22 to 28

Cheers
Leo

Here is my test file and my steps have been to click commandbutton on Database Sheet which brings up the userform. I select February in CB1 and 2016 in TB1 and then hit Generate Report
It is not working for some reason. I am sorry, I am not very experienced with vba. Thanks so much for you help

Maybe it is the different beetween version 2007 en 2016
i have good result with the last file as well

I am using Office 2016..