View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Smithz
 
Posts: n/a
Default 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