Here's a rundown of what I have:

Excel 2003

In my spreadsheet, I have only one worksheet (tbl_hours_query)
In this worksheet, A1 = my header name "Employee", B1 = "Hours".
A2: A25 = all my names, B2:B25 = hours for these employees.

I highligthed A1:A25, named the range "Employee"

I highlighted B1:B25, named the range "Hours"

Here's where I'm a lil baffled. I want to use a dynamic data source,
says to Insert, Name, Define, then insert the offset formula which I
do.

Do I do this in the same worksheet as the data, or in a new worksheet?

I use this for the "refers To:"
=OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),2)

Note: I removed the "Data!" when I do this in the same worksheet as my
list, I made a new worksheet, and inserted the worksheet name.

If I do either of these then add in the pivot table, the pivot table
does not update when I add names and hours to the list.

I'm gonna get this, it will not defeat me!!!!!!!!!!!

Thanx.


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