Comparing two worksheets
 

Is there a way to get Excel to look at all of the cells in sheet1, compare
those cells to all of the cells in sheet2, and then output to sheet3 (or
another workbook), values that were missing from sheet2, but were in sheet1?

Here is the background since perhaps there is an easier way to accomplish
what I am trying. I have two databases that I am currently exporting into
Excel. One of the databases just lists all of the machines. The other
database lists the machines and the components that go into those machines.
I am trying to find machines that are not associated with any components, and
components that are not associated with any machines.

Any help would be appreciated.

Comparing two worksheets
 

Have a look he

http://www.cpearson.com/excel/duplicat.htm

"David" wrote:

Is there a way to get Excel to look at all of the cells in sheet1, compare
those cells to all of the cells in sheet2, and then output to sheet3 (or
another workbook), values that were missing from sheet2, but were in sheet1?

Here is the background since perhaps there is an easier way to accomplish
what I am trying. I have two databases that I am currently exporting into
Excel. One of the databases just lists all of the machines. The other
database lists the machines and the components that go into those machines.
I am trying to find machines that are not associated with any components, and
components that are not associated with any machines.

Any help would be appreciated.