Match and merge on new worksheet
 

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?

Match and merge on new worksheet
 

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,

--
-David D


"Traci" wrote:

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?