Report Looking up Data on a different sheet with multiple requirements

EPRock

New Member
Joined
Sep 28, 2018
Messages
1
I have a dataset in a different workbook, and want to pull a list of records with multiple criteria, I could do it with a macro, but wanted to see if I could make it easier using formula.

My Data has the following information sample (Slimmed down)

Specialist Name, Tech Supported, Activity, Time In, Time Out, Notes
Joe Blow, 1234, Drilling Hole, 9/4/2018 08:00, 9/4/2018 14:00, Helped 1234 Drill multiple holes through concrete.
Sam Smith, 2234, Support Ladder, 9/4/2018 14:10, 9/4/2018 14:30, Helped hold ladder due to very windy conditions

I want to build a list at the bottom of a dynamic excel report (when the tech supported is selected) to show a list of requests to the specialist.

I want to bring up a list of interactions based upon a date range criteria (Start Date Y16, End Date Y18, and Tech Supported A15).

Any suggestions?
Thank you in advance.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top