consolidate and compare workbooks in excel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create different workbooks from workbooks 3
Copy/ move selected data from workbooks to seperate worksheets or workbooks 1
Vlookup a text string 6
combine vlookup and match help 5
Refer cell value as part of formula 1
Index and match formula resulting in #REF 5
Consolidate Multiple Workbooks - Excel 2007 1
Consolidate Several Workbooks into One 1

Top