Extract / copy data from another sheet based on date range

[TheJonWithNoH]

I have a sheet (Sheet 2) with a start date in cell A1 and an end date in cell B1.

In another sheet (Sheet 1) I have a list of data, including dates in Column A and data in Columns B, C & D. Most of the dates in Column A are repetitive based on data value in Columns B, C & D.

I need to copy data from Sheet 1 to Sheet 2, including the repetitive dates, but only based on the date ranges on Sheet 2 in cells A1 & B1.

This new list of data on Sheet 2 should start in Column K through N and start in cell K3 through N3.

I have tried using the following formula in cell K1 which tells me how many instances are within the selected date range:

=COUNTIFS(DataDates,">="&StartSortDate,DataDates,"<="&EndSortDate)

I then use the following array formula starting in cell K3 & L3 which makes my workbook run VERY slow, but returns the correct dates & data in columns K & L, but columns M & N are numbers so this formula isn't working.

In K3 I have:{=IF(ROWS(K$3:K3)>K$1,"",TEXT(INDEX(Data1!A:A,SMALL(IF(Data1!A:A>=StartSortDate,IF(Data1!A:A<=EndSortDate,ROW(Data1!A:A))),ROWS(K$3:K3))),"m/d/yyyy"))}
In L3 I have:{=IF(ROWS(K$3:K3)>K$1,"",TEXT(INDEX(Data1!B:B,SMALL(IF(Data1!A:A>=StartSortDate,IF(Data1!A:A<=EndSortDate,ROW(Data1!A:A))),ROWS(K$3:K3))),""))}

How can I get the numbers from Sheet 1 over to Columns M & N? Also, is there a non-array formula that would be better? VBA code possibly?

Here's an example of my data on Sheet 1

10/1/2017	RatePlan A	1	$150
10/1/2017	RatePlan X	5	$500
10/2/2017	RatePlan R	3	$350
10/2/2017	RatePlan W	1	$100
10/3/2017	RatePlan Q	3	$300

<tbody>
</tbody>

Thank you in advance for your help!!!!

 

[jmccullochwork]

just watched a video explaining something similar

i want to do the same but between workbooks so thinking a vb macro is more suited.