Match and merge on new worksheet

[Guest]

Need some help with the following:

I've got two worksheets that are exports of two separate reports. The first
worksheet has 6 columns of data that I need to append to the data in the
second worksheet. If possible, it would be great to have the merged records
written out to a third worksheet. Additionally, I need to match the records
in sheet 1 with the records in sheet 2 by a text field (Project Name).

Is there a relatively easy way to do this in Excel?

 

[Guest]

Traci,

What you're doing could probably be done in Excel after pulling out most of
your hair.

What might be easier (and save you a good deal of hair) is to pull your data
into Access instead. Through Access, you can easily combine your two reports
(through a UNION query) or find/remove duplicates. I guarantee you it will
be easier.

Hope that helps,