I have an Excell work book that contans a number of work sheets with a number
of employees names listed in column "B" and amounts to pay each name in
adjacent column "C". An employee's name is located a number of times in one
column of each work sheet in no corresponding order. ie.. an employee may be
in cells B5, B7and B10 with amounts owing in adjacent cells in column C5, C7
and C10, on one particular sheet and on another sheet may be positioned with
other employees,in B1, B2, B9, B10 and B11, again with adjactent column C
having amounts of monies owed. Is there a way to automatically select an
employees name once from relavent columns from each sheet in work book and
accumulate all amounts of monies in adjacent cells to represent one total
owing to that one employee.