I have two workbooks with different kinds of data (workbook 1 has 30 columns of demographic and workbook 2 has 50 columns of prices.) Some of it overlaps (both have housing and utility cost, and a few other similar columns) and both workbooks have a zipcode column.

I would like to use the zipcode column to merge all the data into a single workbook.

How can I do this?

Thanks.

Darren