V
vitality
hi all!
Can anyone help to solve the follow problem:
Spreadsheet A has the follow column:
-PartNo
-VendorCode
-Quantity
Spreadsheet B has
-PartNo
-PartName
-Unit Price
PartNo in both table are related and unique.
There are thousand of data in each spreadsheet. It is impossible to us
the if statement to join two tables, Also.. I understand it can us
Access to do it very easily, but I do not want to use Access... can
do it in Excel?
Pls help...
How can I join these two tables into one table, has all thos
information, as:
New spreadsheet
-PartNo
-VendorCode
-Quantity
-PartName
-Unit Price
Thank you very much for any suggestion
Can anyone help to solve the follow problem:
Spreadsheet A has the follow column:
-PartNo
-VendorCode
-Quantity
Spreadsheet B has
-PartNo
-PartName
-Unit Price
PartNo in both table are related and unique.
There are thousand of data in each spreadsheet. It is impossible to us
the if statement to join two tables, Also.. I understand it can us
Access to do it very easily, but I do not want to use Access... can
do it in Excel?
Pls help...
How can I join these two tables into one table, has all thos
information, as:
New spreadsheet
-PartNo
-VendorCode
-Quantity
-PartName
-Unit Price
Thank you very much for any suggestion