This is basically how the sheet looks:

Columns: Name Work Hrs. 10/03/04


Rows: Name 1 40
Name 2 38
Name 3 44
and so on....
There are different sheets with work hours from other weeks:
Columns: Name Work Hrs. 10/10/04

Rows: Name 1 41
Name 3 42
Name 4 30
Each sheet is sorted by name in ascending order but some names are
omitted or added depending on the week. For example, how can i get the
sum of hrs for name 3 if it is located in row A4 in one sheet and in
row A3 in another. The info is in different cells.


--
lucylu
------------------------------------------------------------------------
lucylu's Profile: http://www.excelforum.com/member.php...o&userid=16319
View this thread: http://www.excelforum.com/showthread...hreadid=277114