Formula to pull and display all entries in a date range - PLEASE HELP!

[Rebeccah83]

I am building a report which needs to display all entries on a separate sheet where the entry falls into a date range.

Sheet1 (report) The start date is in B3. End date is in D3.

Sheet2 (data) Dates are displayed in column B. Array to pull is Column B through AU.

So, if the start date is 6/15/2016 and the end date is 6/26/2016, I need all rows from Sheet2 where the date falls within that range to display in Sheet1.

BONUS:
I also need to sort based on "Employees". Sheet1 is F3. Sheet2 is column C.
If F3 reads "All Employees", all rows meeting the date criteria should be listed.
If F3 reads "Steve Handy", only rows in the date range and with employee Steve Handy should display.

I have tried multiple formulas so far (several hours of work) and am at my wits end.

Thank you for your assistance.

 

[Trevor G]

Welcome to the forum,

Have a look at recording a macro to apply filters on the sheet and then adapt it to use the cell id's from sheet one, recording is found under the View Tab.

 

[jorismoerings]

Hi,


to add to Trevor:

If your need is formula's will need to know what the max number of lines will be you'll have to pull from the data sheet.
Several options come to mind but looking at your bonus VBA would be most feasible.

 

[Rebeccah83]

Trevor G - As I will not be the one using this report, it is very important I attempt to keep it as automated as possible - leading to my avoidance of macros.

jorismoerings - The maximum number of lines to pull should be 250.

Thank you both for your replies.

 

[Rebeccah83]

Still working to find a solution on this one without resorting to Macros, if possible. Thank you.

 

[Rebeccah83]

Just looked further into Macros. You guys are correct, this may be the only solution. Thank you again.