It is two different workbooks with one worksheet per workbook. The layout is
in columns and the common fields are column c on one sheet and column a on
the other.

"Don Guillett" wrote:

First, let's get the terminology right.
A file is called a workbook
Tabs within are called worksheets or sheets.
What is your layout and what is the common field.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jjacksonn1966" wrote in message
...
I have 2 different spread sheets with one common field. I want to combine
the
two sheets together to have one sheet which has the data from only the
common
field combined. Can someone help with this.