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

Excel - Wich Function should I use? 1
Excel PMT Function Help 2
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Runtime error 424 in Windows 8 environment 15
Help - need to consolidate workbooks 3
combine vlookup and match help 6
Create different workbooks from workbooks 3
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3

Top