| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
load one vendors prices to a master workbook
i have a master vendor price sheet with about 10 different vendors and their
part numbers. when i get a new price update i want to load the workbook from the vendor to the master. i have tried compare and merge, sharing, consolidating and sharing and can't get it to work. my master looks like this: part# Vendor# price 7 PR 7 114.15 PRF 7 98.15 PRC 7 84.26 CT 2029 64.22 C2029 67.60 SPI 7 74.26 432179 104.62 and my workbook that i want to merge has just the vendor # c2029 for 72.00 thanks, yank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Linking 2 workbooks | Excel Worksheet Functions | |||
| Creating a subbook from a workbook. | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| How do I set up a Workbook with a master compiled worksheet and o. | Excel Worksheet Functions | |||
Linear Mode
