I am in construction and deal with expense reports from field employees. We
are trying to automate all to ease data entry of multiple line items containg
the same data. Worksheet 1 is the field data entry sheet. Worksheet 2 would
be the Print sheet that fills in and calculates from sheet 1. Trouble is the
finding the formula to fill in the "Summary" box on sheet 2 by looking at all
single or multiple cells that contain the same data on sheet 1. Because there
are multiple jobs and codes, I want it to find and sum a combination of 3
cells of text (job numbers and codes) and sum a different cell on the same
row without having to list our entire job, phase & category library.
--
Thanks for any help available..

Lisa B