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