Macro - Copy rows based on dates from Sheet 1 to Sheet 2

[chris_excel]

Hi all,

I've found several threads on this but I cannot get any of those to work for me.

I need to a Macro on sheet 'Weekly KPI' to search for rows in sheet 'Trade OP' (dates found in column 'B' on Trade OP sheet) based on dates selected as below from Weekly KPI sheet;

I need to copy those rows from sheet 'Trade OP' to the Weekly KPI sheet to row '8' onwards.

Date input/lookup can be simplified to omit Month Input Cell.

Thanks

 

[My Aswer Is This]

Where exactly do you plan to enter the search for Date?
I do not understand your image.

 

[chris_excel]

Where exactly do you plan to enter the search for Date?
I do not understand your image.

The grey cells circled will be input with search criteria. The w/c (week commencing) date will be the start of a week, so I need the search to be from "this date" to "this date+6days". The blue button will run the Macro to search and copy data.