Comparing 2 Spreadsheets

M

mizzrizz

Hi, I need some advice on the best way to go about comparing two
spreadsheets to create a difference report. A little background....

_FILE_INFORMATION_

Spreadsheet 1 - list of program/file names and version numbers that
developers submit in preparation for a software release.

Spreadsheet 2 - list of program/file names and version numbers that a
software control program creates.

Both spreadsheets have an identical amount of columns and the are named
the same. Each spreadsheet has a different quantity of rows. The primary
information to compare on each spreadsheet is Program/File Name (column
A) and Version Number (column B).

_PUPROSE_OF_THIS_TASK__

Sometimes the software control tool includes program files in error and
those need to be identified for review. This would be the cross match on
columns A and B from spreadsheet 1 to 2.

Conversly, the software control tool (or the person doing it) misses
program files, which also need to be identified. This is the cross
match on columns A and B from spreadsheet 2 to 1.

_DESIRED_OUTPUT_

I'm hoping to come up with an automated solution since each of these
files can have upward of 2000 rows. We manually review now and it's
extremely time consuming. What I hope to do is have a solution the
generates a third spreadsheet (Difference Report) the shows the
following -

1. The following rows from spreadsheet 1 were not on spreadsheet 2.
2. The following rows from spreadsheet 2 were not on spreadsheet 1.

I'm hoping for input on whether or not I can do this with Excel.. would
it be a function/formula? A macro? VBA? Abandon Excel and use
Access?:eek:

Thanks for your help. If anyone has the time to work a solution for
this, I do have a some data to play with. ;)
 
M

mizzrizz

Thanks, Tom. Looks like there are some good nuggets on that link that
you sent. I will check it out!
 

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

Comparing data (conditionally) between two spreadsheets 3
comparing a column in two separate spreadsheets 2
combining data from 2 sheet into new sheet based on like values 2
2 spreadsheets - populating one by multiplys of another 3
convert columns to rows 6
Copying data from several spreadsheets into a new spreadsheet 2
export data between spreadsheets 2
Concatinating two spreadsheets by a column 4

Top