| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update column info based on column info from another worksh
I have a worksheet that has many columns. One of the columns contains Vendor
Sku Numbers and another column on the same worksheet contains Price information for that Part Number. I need to update pricing information regularly based on a new worksheet that I receive which has the part numbers and new pricing. How do I update pricing for thousands of parts without having to look at each row and column. example: wks "A": Vendor SKUNumber Descr Price 0120 Bulb 1.35 0115 Pen 2.68 wks "B": Vendor SKUNumber Descr Price 0120 Bulb 1.44 0115 Pen 2.78 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup info in one Column and then returning info in other columns | Excel Worksheet Functions | |||
| Consolidate information from Column B Based on Info In Column A | Excel Worksheet Functions | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| Update a column data with info from new worksheet | Excel Discussion (Misc queries) | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Threaded Mode
