Merging of Worksheets
Hi there,
I have two worksheets of data that are connected by a common field. I want
to merge these two worksheets (similar to how one might link up two DB
tables).
Is there a way I can do this in Excel.
Therefore the end result would be a single worksheet, and whenever the value
in the column that I choose from each worksheet matches, a single row in a
new worksheet is created.
(and where there is no match a new row is added, but does not have all the
columns populated).
Hope this makes sense.
Kind regards
Dave
|