| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update list data
Hi,
Below are two lists. Data is located in the first two columns. Each list has over one thousand items. How do you write a program to update only the prices in the old list using the data from the new list? Old.xls New.xls AA1 12.25 AA1 11.50 AA2 20.45 AA2 7.20 ------ ------- ------ -------- ------ ------- ------ -------- BB1 30.20 BB1 30.00 BB2 46.60 BB7 18.45 ------ ------- ------ -------- ------ ------- ------ -------- ZZ46 56.35 ZZ21 14.00 The columns are different in length and their items don't match completely. Much appreciate if anyone can help. TIA tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Update of Dropdown List Box data | Excel Worksheet Functions | |||
| Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
| how do I update a list to overwrite duplicates with new data | Excel Discussion (Misc queries) | |||
| update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
| Update Excel Data List for Drop Down use | Excel Discussion (Misc queries) | |||
![tom[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
