| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linkage data between two spreadsheet
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 use the if statement to join two tables, Also.. I understand it can use Access to do it very easily, but I do not want to use Access... can I do it in Excel? Pls help... How can I join these two tables into one table, has all those information, as: New spreadsheet -PartNo -VendorCode -Quantity -PartName -Unit Price Thank you very much for any suggestion. -- vitality ------------------------------------------------------------------------ vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267 View this thread: http://www.excelforum.com/showthread...hreadid=467742 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
| When entering data into excel spreadsheet cell, the page just jum. | Excel Discussion (Misc queries) | |||
| When entering data into excel spreadsheet cell, the page just jump | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
