View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SC Diane SC Diane is offline
external usenet poster
 
Posts: 1
Default consolidate and compare workbooks in excel

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.