Both excel worksheets have 4 columns:
employe ID, last name, first name, cost

I'm want to see if excel can do the matching/reconciling instead of me doing
it manually.
--
Ms. Davis


"Joel" wrote:

I usually start with one report then add the second report to the first by
matching the ID's. If the ID's match add the second report to a new
column(s). If the second report ID does not match then add a new row to the
report and the data to the new column(s). The rows where there isn't datta
for both reports is the reults you are look for.

I need to know the number of columns ineach report and the column which
contains the ID's.

"Pinkiredd" wrote:

I'm trying to reconcile billing that are in excel format. Both billings have
employee ID numbers. Is there a way I can merge the two files together and
get the desire results of who is not one what report?
--
Ms. Davis