Hi Heather,

If I understand what you want, I would use formulas.

You could put the Over/Under sheet in the Time workbook.

In column A:A, place the list of employees--names or ID numbers--
however you identify them in the Time workbook.

Then in column B:B, put vlookup formula that uses your pivot table as
your table array.

The formula will look something like:

=VLOOKUP(A1,Time!A1:E500,3,FALSE)

Dan