| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 files and Update
I am trying to compare and update 2 Excel files.
Both files have the same information, product ID number and quantity. I want to compare file 1 (master) with file 2 (updated). I want to verify that the product ID numbers are the same, if so, then update the quantity with the newer number. Column A Column B ------------------------------------- Product ID Quantity 12345 25 *Product ID & Quantity are headers, columns A & B are just for reference. I would like generate a new updated file in the original format Thanks for any suggestions. Harold |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare 2 files and Update
use the vlookup formula. See Excel help on Vlookup.
-- Regards, Tom Ogilvy "Suncoast" wrote in message oups.com... I am trying to compare and update 2 Excel files. Both files have the same information, product ID number and quantity. I want to compare file 1 (master) with file 2 (updated). I want to verify that the product ID numbers are the same, if so, then update the quantity with the newer number. Column A Column B ------------------------------------- Product ID Quantity 12345 25 *Product ID & Quantity are headers, columns A & B are just for reference. I would like generate a new updated file in the original format Thanks for any suggestions. Harold |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two files and update data from another file base on words ina cell separated by commas | Excel Worksheet Functions | |||
| Compare and update spreadsheets | Excel Discussion (Misc queries) | |||
| 2 files, mass update comments between files | Excel Worksheet Functions | |||
| UPDATE & COMPARE | Excel Programming | |||
| Compare and update please help | Excel Programming | |||
Linear Mode
