Copy/Paste Dynamic Range based on Match Function

Greetings,

I am trying to write a macro that will copy a dynamic range of cells based on a criteria input. More specifically, I want to pull attendance report for any one employee based on a data dump to a separate worksheet.

My hope was to have 'Agent Detail'!E2 as the dropdown to select the employee I want to see. Then, by activating the macro, have that employee's information found on the Attendance Dump tab, then copied and pasted to the Agent Detail tab in the designated columns.

The macro has to be able to define the range dynamically, as the number of rows in the report will change over time.

I have attached the file for reference.

My VBA is so limited that I haven't even been able to troubleshoot my meager attempts to make this work.

I thought using a Match function might be the place to start, as that would define the row I need to start the range on, but I'm struggling to figure out how to define the ending row of the range.

I also have no idea how to properly write the syntax for WorksheetFunction object.

Any help would be appreciated.

I resolved this via research.