Currently, there isn't an Over/Under sheet. I need to create that.
The layout of the pivot table is this:
Resource, Role, Project as Rows. Jan 08, Feb 08, Mar 08, etc through to Dec
08 in Data.
The fields that I am referring to are the months of the year.
If the data in any month field *on the resource's Total row* (because
Resources work on more than one Project) is greater than one, I want the
entire row to be copied and dropped from the Pivot table sheet and dropped
onto the Over/Under sheet.
I also need to track Underallocation (less than .80) in the month fields and
have that information drop into a different part of the Over/Under sheet.

"dan dungan" wrote:

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