Hello:

I have two Excel files and need to compare and consolidate
them.

In one worksheet, I have a list of items that need the
information from the second worksheet apended. For
example; in one sheet I have items 4, 5, 6 in one column
with no other data. On the second sheet I have items 1
through 10 with additional colums of data.

I would need the result of the compare to be items 4, 5,
and 6 (which appear on both sheets) with all the column
data from spreadsheet two added to the result.

Any help would be appreciated.

-Steve