Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linkage data between two spreadsheets
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? 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. Pls help... since I am not good at any macros or programming skills i Excel, pls kindly explain in a little details as possible -- vitalit ----------------------------------------------------------------------- vitality's Profile: http://www.excelforum.com/member.php...fo&userid=2726 View this thread: http://www.excelforum.com/showthread.php?threadid=46774 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linkage data between two spreadsheets
in the sheet B add two columns vendor code and quantity
name the whole data in sheetA for e.g. as "vendor" against each part no. in sheet B in the vendor code column, type =vlookup(partno. cell address,vendor,2,false)- part no.cell address in sheet B similarly aginst quantiy column ,type =vlookup(partno.cell address,vendor,3,false) copy these two down. the vendor code and quantity from sheet A will be copied on sheet B do this experinet for a few rows and see whehter you get what you want there may be other methods. -- remove $$$ from email addresss to send email "vitality" wrote in message ... 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? 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. Pls help... since I am not good at any macros or programming skills in Excel, pls kindly explain in a little details as possible. -- vitality ------------------------------------------------------------------------ vitality's Profile: http://www.excelforum.com/member.php...o&userid=27267 View this thread: http://www.excelforum.com/showthread...hreadid=467743 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linkage problem | Excel Discussion (Misc queries) | |||
Cell linkage ... | Excel Discussion (Misc queries) | |||
Linkage problem between spreadsheets | Excel Worksheet Functions | |||
worksheet linkage | Excel Discussion (Misc queries) | |||
Linkage data between two spreadsheet | Excel Worksheet Functions |