Hey Ron....think I got it working. I think the mistake I was making was
that I was creating the "Insert, Name, Define + offset formula" for
both the employee column and the hours column. Every time I insert new
names and hours, the pivot table was not updating. I deleted everything
in "Insert...Names......" just inserted the "Employee name with the
offset formula, changed the last numeral to "2" (2 columns), and it
seems to be working.

I made the pivot table appear in a new worksheet, added names and hours
to the list, updated the pivot table and it seemed to update fine.

Thanx for all the help (and patience!). It's definetly a nice little
tool we'll be using for quite some time.

Thanx again...Jim


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=546477