I have data exported into excel from another program. The way the data is
presented is as follows:

Employee Name
Date data
Date data
Date data
Date data
Date data
Date data

Another Employee Name
Date data
Date data
Date data
Date data

and on and on,

What I'm trying to do is make a new tab that lists all of the employee names
in a row and dates down a column and then use a look up function (I was
trying index, match) to compare the dates from both tabs enter the data for
each employee. The problem I'm facing is that under each employees name
their are a different number of rows (some people didn't work some days), so
I want to make the range for the look up to compare dates going down the
spreadsheet only until it hits a new employees name (or hits a row with the
word "agent" in it) then I want it to continue comparing the dates and
entering the data, but I want the next employees data to show up under their
name on the new spreadsheet. How do I make it so I don't have to choose a
set range? But make it so it looks between two values? Aaaagh sooo confused.