consolidate and compare workbooks in excel

  • Thread starter Thread starter SC Diane
  • Start date Start date
S

SC Diane

I have a list in excel (version 2003) with employee data that I need to match
to an insurance billing. Both workbooks have Employee names, SS#'s, Insurance
Type and Insurance amounts. I need to combine these 2 workbooks so the data
is arranged in the consolidated workbook side by side according to SS# so I
can compare the insurance amounts for each employee and calculate the
differences.
 
Back
Top