Hi Heather,

I'm not sure I understand what you need. I'm not able to visualize
your situation. My hopefully clarifying questions are below:

On Mar 24, 9:01 am, Heather wrote:
I have a spreadsheet that tracks time for all employees across all projects.

What is the name of this spreadsheet?

And I will start a sheet to track employees that are over or under the
alotted monthly time.

Is this the Over/Under sheet?

So I need to have the Over/Under sheet open the Time workbook, search the
TOTAL for each employee (there's a Pivot table that tracks the Total for each
employee) and then copy any TOTAL row that has a greater than 1 total in it.

What is the layout of the pivot table? I don't understand how you
would have a Total row. I am imagining a Total Column.

This sheet tracks each month of the year, so I need it to check those fields.

Which fields? How do these fields relate to the month of the year?

Dan