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 |
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 |
All times are GMT +1. The time now is 04:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com